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

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. 


  • Options
    RichardLRichardL Posts: 417 Gold 4
    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. 
    Customer Support
    Redgate Software
Sign In or Register to comment.