Real Time Two Way Replication

#1

Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100% real
time like we can't wait 3 seconds to replicate the data into another Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#2

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#3

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#4

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#5

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#6

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#7

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#8

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#9

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.

#10

Thanks Ekrem,

There are two purpose for these two way replication.

1. For Load Balancing
2. Failover.

Thanks

"Ekrem Önsoy" wrote:

Quote:

Failover Clustering is not a replication solution by itselt, it's used as a
High Availibility solution. Database Mirroring must be the fastest one as a
SQL Server solution however as you mentioned you can't use the Mirror
database as a server just like the Principal.

Do you want to use the second server as a reporting server or are you
willing to manipulate data on that server too? If you mean to use the second
server only for a reporting server then you can use Database Snapshots with
Database Mirroring. So you'll be able to run SELECT queries against your
Mirror database' s Snapshot. By the way, this feature can be used only for
Enterprise Edition.

If you want to manipulate data on the second server, then consider P2P
Replication (http://msdn.microsoft.com/en-us/library/ms151196.aspx)

Merge replication is more appropriate for "Server <-> Client" topologies...

--
Ekrem Önsoy

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:AB0FB227-3798-416A-B760-E48C242D142A (AT) microsoft (DOT) com...
Hello Guys,

I would highly appreicate if any one can help me out on that...

I was looking for Real Time two way replication but this should be 100%
real
time like we can't wait 3 seconds to replicate the data into another
Server...

I was using Database Mirrioring which is Active and Passive but I need
Active / Active solution so we can use load balancing and also use for
Disaster Recovery. Not sure about Peer to Peer Replication, will it
faster
than Merge Replication?

Please adivce which one is the best soltuion is terms of very quick real
time replication, I talked to couple of people and they were referring
Clustering (hardwar solution) but can't we handle through Database
Replication ?

Please advice

Thanks in advance.