What are the challenges you face when working across database platforms? Take the survey

SQL Data Compare selected tables only (command line)

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.



Sign In or Register to comment.