I am doing research about SQL Server Data Replication since last week. I have a project which requires replicating selected data of selected tables from 1 sql server to another.
The SQL Server that I am using is SQL Server 2000 Standard Edition. And of course it doesn’t come with Replication feature. The Replication feature only comes with Enterprise Edition, but of course the cost of edition upgrade is definitely gonna be pricey.
The other alternative that I came across with is Redgate’s SQL Data Compare software. SQL Data Compare is used for automating data migrations, analyze corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It is very cost effective, as it costs only about 400 – 600 USD per license.
Of course, I will still need to do a comparison for both softwares mentioned above. But I am really tempted with Redgate :)
Or anyone out there has better suggestions? Recommendation is most welcomed here. Cheers!!
No comments:
Post a Comment