Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

synchronizing pre-production with production Expand / Collapse
Author
Message
Posted Tuesday, October 20, 2009 2:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, October 20, 2009 7:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
You can set up snapshot replication if you want to...

-Roy
Post #805666
Posted Tuesday, October 20, 2009 7:17 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:31 PM
Points: 32,780, Visits: 14,941
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
Posted Tuesday, October 20, 2009 7:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, October 20, 2009 7:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
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 »

Add to briefcase

Permissions Expand / Collapse