Table data copy without row by row comparison?
Proto
Posts: 13 Bronze 2
Is it possible to use data compare to copy the entire contents of a table without using the row by row comparison?
For example, to copy data from live down to dev.
The tables i'm dealing with are much too large to run the row by row data compare on, the program just kind of hangs. Anyway, i'm not interested in the individual row comparisons, I'd just like a list of tables with any data differences that I can select from. Then I just want to wipe the dev tables and replace them with the live data.
For example, to copy data from live down to dev.
The tables i'm dealing with are much too large to run the row by row data compare on, the program just kind of hangs. Anyway, i'm not interested in the individual row comparisons, I'd just like a list of tables with any data differences that I can select from. Then I just want to wipe the dev tables and replace them with the live data.
Tagged:
Answers
Thanks for your post.
This isn't a feature in SQL Data Compare. The is a function that can be completed from within SQL Server itself.
I hope this helps.
Richard Lynch.
Redgate Software