synchronizing pre-production with production

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » synchronizing pre-production with production

synchronizing pre-production with production

Rate Topic

Display Mode

Topic Options

Author

Message

Heisa

Posted Tuesday, October 20, 2009 2:25 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, July 14, 2011 3:15 AM
Points: 18, Visits: 63

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

Post #805504

Roy Ernest

Posted Tuesday, October 20, 2009 7:11 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:27 AM
Points: 3,280, Visits: 6,623

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

-Roy

Post #805666

Steve Jones - SSC Editor

Posted Tuesday, October 20, 2009 7:17 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #805673

Heisa

Posted Tuesday, October 20, 2009 7:23 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, July 14, 2011 3:15 AM
Points: 18, Visits: 63

Thanks all!

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

Regards,
Heisa

Post #805682

Roy Ernest

Posted Tuesday, October 20, 2009 7:51 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:27 AM
Points: 3,280, Visits: 6,623

After you read up and test it out, if you have any problems, feel free to post the issue.

-Roy

Post #805720

« Prev Topic | Next Topic »

Permissions