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, andy.campbell.smith
My company is evaluating SQL Source Control 3. Static data management is the primary motivation in exploring this software.
I realize you can't undo static data changes (yet???). But seems like there should be some way to manually workaround it. Can you please let me know the best way to work around this limitation and effectively undo my changes?
- Posts: 3
- Joined: Fri Feb 24, 2012 10:10 pm
You should be able to rollback static data using Red Gate's SQL Data Compare - if you have a license for this product. You will need to populate a scripts folder with the the schema and data changes you want to rollback to and then deploy that back to your development database. You could then commit the changes in SQL Source Control to effectively rollback the data.
SQL Data Compare v10.0 will be realeased in the next few weeks that will enable a new button on the SQL Source Control v3.0's History Dialog allowing you to rollback static data to a selected version.
- Posts: 117
- Joined: Thu Jun 30, 2011 2:15 pm
- Location: Cambridge
Return to SQL Source Control 3
Who is online
Users browsing this forum: No registered users and 1 guest