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!