v2.0 RC - Supports Static Data and Shared Model

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

v2.0 RC - Supports Static Data and Shared Model

Postby sherr » Wed Dec 01, 2010 9:44 pm

For Subversion / Team Foundation System users, the v2.0 Release Candidate (RC) is now available!

New Features:
- Static Data – Source control your reference data alongside your schema directly from SSMS
- Shared Model – Know who is making changes to the shared db, commit only your own changes by default, and we fixed the conflict issue (you will need to unlink and relink any existing linked dbs if you want to change to this model)
- Evaluation Repository - Try out SQL Source Control with a local SVN repository to have a quick and easy evaluation

Download the v2 SVN/TFS RC

We need your feedback:
- If you have any issues, please post them on this support forum or contact our support team at support@red-gate.com
- If you have any suggestions for new features, enhancements, or things you would like to see, then please vote or comment on our Suggestion Forum

If you are using VSS, Vault, Vault Pro (Fortress), Mercurial, GIT, or any other source control system, then sign up for our Early Access Program to get information about a releases that support these systems.
Last edited by sherr on Tue Mar 01, 2011 8:16 pm, edited 6 times in total.
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby AndrewJacksonZA » Fri Dec 03, 2010 8:19 am

Thank you very much for the Static Data feature, we appreciate it!
AndrewJacksonZA
 
Posts: 17
Joined: Wed May 05, 2010 11:09 am
Location: Johannesburg, South Africa

Postby camaro322hp » Fri Dec 03, 2010 9:12 pm

Yes, thank you for this. I have installed and already run it through some paces. It seems to be working well so far. The only thing I noticed is that when you have data in source control, and you get latest from that to a blank database, the first get latest only gets the schema, not the data. If you get latest a second time, then you will get the data. Not sure if this is by design or not. Subsequent get latest requests will get both schema and data changes.

This will make our DB source control much easier. Looking forward to the final release of this.
camaro322hp
 
Posts: 3
Joined: Fri Dec 03, 2010 9:07 pm
Location: Portland, OR, USA

2 Step Process

Postby sherr » Mon Dec 06, 2010 2:12 pm

Hello,

Thanks for the feedback.

Committing/Getting the data is currently a 2 step process because you have to commit/get the schema first and then the data will appear on the list and you can then commit/get the data. We hope to fix this in a future release so the process is more streamlined.

March 1 2011 - The release candidate now allows atomic commits/gets of both schema and data so this is no longer a 2 step process.
Last edited by sherr on Tue Mar 01, 2011 8:18 pm, edited 1 time in total.
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby camaro322hp » Mon Dec 06, 2010 10:56 pm

Stephanie - It appears that the "Undo Changes" functionality does not recognize data changes to the tables with source controlled data. It appears to only recognize schema changes.
camaro322hp
 
Posts: 3
Joined: Fri Dec 03, 2010 9:07 pm
Location: Portland, OR, USA

No Undo for Data

Postby sherr » Tue Dec 07, 2010 11:57 am

Camaro322hp - We have not implemented the "undo" feature for data yet. This is an Early Access Release, so there is still work in progress. How important is this feature for you?

If you need to undo right now, please use SQL Data Compare. Using your source control get the latest version (at the db level, not just the data folder) to a local folder. Then you can compare that scripts folder to the db and use SQL Data Compare to synchronize the changes. There's a 14 day fully functional trial at www.red-gate.com/products/sql_data_compare/ (let us know if your trial expires and we'll issue you with an extension)

I hope this helps!
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby camaro322hp » Tue Dec 07, 2010 10:10 pm

Thanks Stephanie. I do have Data Compare and can use that for the time being. I just thought I'd mention it in case it was supposed to be working now, to let you know it wasn't. Thanks for the reply. I do hope this is being considered for the final release.
camaro322hp
 
Posts: 3
Joined: Fri Dec 03, 2010 9:07 pm
Location: Portland, OR, USA

Suggestion Forum

Postby sherr » Thu Dec 09, 2010 3:26 pm

If you want, you can vote/comment on the "Undo Data" feature suggestion at http://redgate.uservoice.com/forums/390 ... a-changes/. We'll update the status on this suggestion once we start working on it.
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control 2 EAP

Who is online

Users browsing this forum: No registered users and 0 guests