Data Compare Data Update Script - must it be all or nothing?

Data Compare Data Update Script - must it be all or nothing?

• Thomaschr

  John Paul Cook wrote:

  that will work only when I am patient!

  I'm not sure what the problem is here. You are aware that when you us use "Select Source/Target Database" there is a second page to the Dialog ("Next" at the bottom of the dialog) One check on "tables" will select all tables, uncheck "tables" and all tables are unselected (as you desired).

  When all are unselected as above then you can choose one or more tables individually (expand the node "tables"), infact modify this down to field level, and then click finish. Only the selected tables are processed and offered in the results of the data compare.

  If you then decide you don't need one of the previously selected tables, it's only one click. I find it quite responsive. What of course can affect the duration would me millions of records, but that is as much a transport problem (depending on where the source is) as well as a factor in generating the script.

  Is this the answer you are looking for, or am I missing your point entirely

  Alle

  BTW- one critisism I would have of the data compare is that up to and including CTP7 you can not save the scenario in the IDE.  What this means, is that if you have a large compare (not already filtered in the "Select Source/Target Database") it does take awhile to regenerate the script (Adventure Works compared to an empty DB complete takes about 1,5 minutes and can not be displayed in the editor because of it's size).

  If I then change the selection in the Data Compare UI to delete one table then it takes that long again because it's doing all the generation again. But that is also 466 MB .sql file being generated / saved each time you refresh. Open that script up in an editor and you will find the loading time in the editor is more than the generation time. (Gets close to 1,000,000 lines and includes error reporting)

  
  

• j_ames2006

  Yes, I can see the script. Uncheck all and then check one at a time - that will work only when I am patient!
  

• RaviKanthReddy

  Looking at your post, I wonder if you are seeing the update script at all

  Data -> Data Compare -> Show Data Update Script or use the button in the Toolbar Show Data Update Script

  Alle

  
  

• osamaT

  Your previous post already answered my question, thanks.
  

• Arjun B

  Hi John,

  for some reason my home installation does not want to compare tonight ! Probably too tired at midnight here.

  Anyway, as in schema compare you can also in data compare right click the object type (i.e. tables) and "unselect all". Do the same for the other objects you do not want (views, etc.) and then expand the tables to select the one you want.

  When all is right, use the "refresh script" button and you should only have a script for that item. By using the menu item Data -> Data Compare -> Select Source/Target Database you can set the "defaults" for this compare which would save some unselecting afterwards.

  Alle

  
  
• Data Compare Data Update Script - must it be all or nothing?