Tips for versioning data?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Tips for versioning data?

Postby bdbowman » Tue Mar 15, 2011 6:22 pm

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.
bdbowman
 
Posts: 3
Joined: Tue Mar 15, 2011 6:12 pm

Postby David Atkinson » Tue Mar 15, 2011 7:21 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby bdbowman » Tue Mar 15, 2011 7:52 pm

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.
bdbowman
 
Posts: 3
Joined: Tue Mar 15, 2011 6:12 pm

Postby David Atkinson » Tue Mar 15, 2011 8:08 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby bdbowman » Tue Mar 15, 2011 9:41 pm

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.
bdbowman
 
Posts: 3
Joined: Tue Mar 15, 2011 6:12 pm


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron