SQL Data Compare selected tables only (command line)

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

SQL Data Compare selected tables only (command line)

Postby gbargsley » Fri Nov 08, 2013 6:13 pm

I am currently working to automate the process of updating our development environment with production schema and lookup table data.

I have figured out how to take a snapshot of production and compare the development environment against that with command line.

My challenge now is to figure out how to take a snapshot of X number of tables in production and compare just those X number of tables in development.

My challenge is that the development environment does not talk to production and the databases are to large to backup/restore.

So my solution is to create RedGate snapshots of schema and hopefully data for only tables I choose and then do the compare and update in development from there.

Any ideas or better suggestions would be appreciated.

Regards
gb
gbargsley
 
Posts: 3
Joined: Wed Mar 30, 2011 2:50 pm
Location: --None--

Postby Manfred.Castro » Fri Nov 08, 2013 11:11 pm

A SQL Compare snapshot is a binary file containing information about the structure of a database; it does not contain any table data.
http://documentation.red-gate.com/displ ... +snapshots

You could try using scripts folders.
http://documentation.red-gate.com/displ ... ts+folders
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest