October 20, 2009 at 2:25 am
Hello,
I have a question about synchronizing SQL Server databases (on the same server).
I am not (yet) familiar with the synchronization bussiness in SQL Server, I am wondering what the best way is to set up the sync.
Not all the tables in the databases need to synced.
There is no need for a data or schema comparisons.
I've downloaded a trial version of the Red Gate Toolbelt, which seems to work great when you need to compare the two databases before the sync.
Is it best pratice to create a DTS package to do the sync? And schedule this every night in a batch? Or are there other tools which will work better?
Thanks in advance!
Regards,
Heisa
October 20, 2009 at 7:11 am
You can set up snapshot replication if you want to...
-Roy
October 20, 2009 at 7:17 am
If you only want certain tables, replication is the only choice. Other options will move all data/tables.
Be sure that you are not moving information that might be a security issue. There are people that worry about having things like credit cards, birthdates, etc. in a non-production environment when security is lower. you might want to use an SSIS package in that case and obfuscate date.
October 20, 2009 at 7:23 am
Thanks all!
I'm going to read up on the (snapshot) replication of SQL Server.
Regards,
Heisa
October 20, 2009 at 7:51 am
After you read up and test it out, if you have any problems, feel free to post the issue.
-Roy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply