Red Gate forums :: View topic - Saving state of GUI compare
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Saving state of GUI compare

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
barryryan



Joined: 16 Sep 2011
Posts: 5

PostPosted: Thu Oct 20, 2011 7:01 am    Post subject: Saving state of GUI compare Reply with quote

We are comparing a before and after batch database of 180 million rows.

The compare takes c. 3h 30 minutes.

Once run I would like to be able to browse and refer to the results over a number of weeks. At the moment the UI needs to stay loaded for this to happen.

I can save the export the comparison as CSV but can't graphically load these into the standard compare view without re-running the whole compare.

Is there a feature to "save the compare" and re-load it OR open one of the exported CSV and view the differences in the UI (avoiding custom coding a UI ourselves to process the CSVs)?
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Thu Oct 20, 2011 11:21 am    Post subject: Reply with quote

Hi Barry,

I'm afraid what you're after can't be done with the current functionality in Data Compare, but I've logged a feature request for you, reference SDC-1281. Sorry I couldn't be more help with this.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
Laura Mandanas



Joined: 26 Oct 2011
Posts: 1
Location: Austin, TX

PostPosted: Wed Oct 26, 2011 10:33 pm    Post subject: request seconded! Reply with quote

I second this request.

I'm having the same problem. I tried to copy all and paste it into Excel to save, but even attempting this causes the GUI to freeze up so that I have to restart the program and rerun the comparison. I have so much data that the exported csv can't be opened properly or even imported into another database.

I would love to have more complete summary options so that there was no need for this. The reason I'm trying to export it is that I want find out the total number of mismatched entries by column. For now, I am going back to my original databases and writing SQL code to sum these up for me.

Any suggestions on how else to do this (within SQL Data Compare or otherwise) are welcome!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group