Red Gate forums :: View topic - SQL Data Compare selected tables only (command line)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

SQL Data Compare selected tables only (command line)

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
gbargsley



Joined: 30 Mar 2011
Posts: 3
Location: --None--

PostPosted: Fri Nov 08, 2013 6:13 pm    Post subject: SQL Data Compare selected tables only (command line) Reply with quote

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
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Fri Nov 08, 2013 11:11 pm    Post subject: Reply with quote

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/display/SC10/Working+with+snapshots

You could try using scripts folders.
http://documentation.red-gate.com/display/SDC10/Working+with+scripts+folders
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group