LIVE Replication - 3rd Party Tool ?? Which one?

[sanjdhiman]

Hi

I am currently running SQL Server 2005 - Standard in a cluster and want to replicate this out. I do need to keep the subscriber in sync all the time (Live).

I dont want to use the in-built SQL Replication as I think it is resources intensive and they havent got it right.

Database is highly transactional and it doesnt cope.

My question is, does anyone know of a good vendor (3rd party tool) that does replication of SQL Server. Highly fault tolerant etc.

Thanks

Sanj

 

[ptheriault]

Check out Datamirror.

http://www.datamirror.com/

I've used it to replicate AS400 to SQL Server and it works very well. There is also a product named Xosoft but I've never used it.
However,I've been using Native SQL Server replication for a long time now on some very transactional databases and never had any major issues.

What is it you feel they haven't got right yet?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

We use transactional replication a lot on some VERY transactional databases without an issue.

What is the end result that you are trying to get with the duplicate database? Maybe database mirroring will work for you?

How many transactions per second are you dealing with?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sanjdhiman]

Per second, not sure, but we get about 5mm hits per day. We insert a lot rather than read, so the shape is a bit different.

We are in a cluster (Active-Active), so mirroring I dont think is an option.

Any other ideas?

 

[ptheriault]

How many transactions per minute do you have? I have a database that has over 1,000 transactions per minute with transactional replication for multiple subscriptions without any problems. Anyway, if you really don't want to use it check out Datamirror.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[sanjdhiman]

Hi Paul

thanks for the reply.

Ok is there a good resource on the net to get replication via SQL SERVER 2005 replication working correctly.

Thanks

Sanj

 

[ptheriault]

First you need to determine which type of replication you want to use. Here is a link that describes the 4 types.

Transactional
Merge
snapshot
peer to peer. (new to 2005)

http://msdn2.microsoft.com/en-us/library/ms152531.aspx

Once you know what you want this link will help you set it up.

http://msdn2.microsoft.com/en-us/library/ms151847.aspx

Google is your friend on this subject. There are tons of articles on how to set up and configure replication.

Just google SQL Server replication. or
How to configure SQL Replication

- Paul

- If at first you don't succeed, find out if the loser gets anything.