Expert Advice

#1

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#2

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#3

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#4

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#5

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#6

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#7

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#8

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#9

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

#10

1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Quote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks