Red Gate forums :: View topic - Tips for versioning data?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Tips for versioning data?

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bdbowman



Joined: 15 Mar 2011
Posts: 3

PostPosted: Tue Mar 15, 2011 6:22 pm    Post subject: Tips for versioning data? Reply with quote

We are currently evaluating SQL Source Compare 2 for a shared dev environment. We have linked the data for 3 tables ranging in size from about 20,000 records to about 160,000 records. Currently, it takes about 15 minutes for the commit changes tab to refresh, and I was wondering if there are any tips or best practices to look at to speed this up.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1112

PostPosted: Tue Mar 15, 2011 7:21 pm    Post subject: Reply with quote

160,000 records is a huge static data table! Can I ask what sort of data this is?

In our research we generally found that static data tables were a lot smaller than this. If we were wrong, we'll definitely have to review the tool's performance.

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
bdbowman



Joined: 15 Mar 2011
Posts: 3

PostPosted: Tue Mar 15, 2011 7:52 pm    Post subject: Reply with quote

It is essentially a list of insurance policy documents broken down by coverage type and state. It is also not strictly static, but it is only updated about once every 2 weeks or so and it would be nice to be able to track the changes and who made the change.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1112

PostPosted: Tue Mar 15, 2011 8:08 pm    Post subject: Reply with quote

Thanks for the clarification. Does this mean you're using SQL Source Control to track data changes made in the live production database? Or are you referring to changes made to this data in your development environments?

David
Back to top
View user's profile Send private message Send e-mail
bdbowman



Joined: 15 Mar 2011
Posts: 3

PostPosted: Tue Mar 15, 2011 9:41 pm    Post subject: Reply with quote

The changes to the data are made in dev and then promoted to test and eventually live. The process for the data changes in these tables is pretty similar to what we do with our schema changes we are also tracking with SQL Source Control.
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