How can we help you today? How can we help you today?

Table data copy without row by row comparison?

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.
Proto
0

Comments

1 comment

Sort by
  • RichardL
    Hi @Proto

    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.
    RichardL
    0

Add comment

Please sign in to leave a comment.