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

Can SQL Data Compare remember a sequence of tables to affect?

ShowJShowJ Posts: 1 New member
edited August 19, 2020 2:32PM in SQL Data Compare
I recently inherited a database with a lot of primary keys, foreign keys, and enforced referential integrity. As a result, whenever I use SQL Data Compare to refresh the DEV database with data from PROD, I can't just select all the tables and rows at once and let Data Compare do its thing...there seems to be a specific order I have to go in, which is time consuming.

I was wondering if SQL Data Compare had a means of setting a specific order in which tables are affected.
Tagged:

Answers

Sign In or Register to comment.