InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 19:33:49 GMT20http://www.sqlservercentral.com/Forums/Topic805504-7-1.aspxAfter you read up and test it out, if you have any problems, feel free to post the issue.Tue, 20 Oct 2009 07:51:53 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic805504-7-1.aspxThanks all!I'm going to read up on the (snapshot) replication of SQL Server.Regards,HeisaTue, 20 Oct 2009 07:23:08 GMTHeisahttp://www.sqlservercentral.com/Forums/Topic805504-7-1.aspxIf 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.Tue, 20 Oct 2009 07:17:24 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic805504-7-1.aspxYou can set up snapshot replication if you want to...Tue, 20 Oct 2009 07:11:28 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic805504-7-1.aspxHello,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,HeisaTue, 20 Oct 2009 02:25:59 GMTHeisa