Post reply

synchronizing pre-production with production

  • October 20, 2009 at 2:25 am

    #94021

    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

    #1068155

    You can set up snapshot replication if you want to...

    -Roy

  • October 20, 2009 at 7:17 am

    #1068160

    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

    #1068168

    Thanks all!

    I'm going to read up on the (snapshot) replication of SQL Server.

    Regards,

    Heisa

  • October 20, 2009 at 7:51 am

    #1068203

    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