Red Gate forums :: View topic - v2.0 RC - Supports Static Data and Shared Model
Return to www.red-gate.com RSS Feed Available

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

v2.0 RC - Supports Static Data and Shared Model

Search in SQL Source Control 2 EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Wed Dec 01, 2010 9:44 pm    Post subject: v2.0 RC - Supports Static Data and Shared Model Reply with quote

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.
_________________
Thank you!
Stephanie M. Herr Smile
Delivery Product Manager


Last edited by sherr on Tue Mar 01, 2011 8:16 pm; edited 6 times in total
Back to top
View user's profile Send private message
AndrewJacksonZA



Joined: 05 May 2010
Posts: 17
Location: Johannesburg, South Africa

PostPosted: Fri Dec 03, 2010 8:19 am    Post subject: Reply with quote

Thank you very much for the Static Data feature, we appreciate it!
Back to top
View user's profile Send private message
camaro322hp



Joined: 03 Dec 2010
Posts: 3
Location: Portland, OR, USA

PostPosted: Fri Dec 03, 2010 9:12 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message MSN Messenger
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Mon Dec 06, 2010 2:12 pm    Post subject: 2 Step Process Reply with quote

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.
_________________
Thank you!
Stephanie M. Herr Smile
Delivery Product Manager


Last edited by sherr on Tue Mar 01, 2011 8:18 pm; edited 1 time in total
Back to top
View user's profile Send private message
camaro322hp



Joined: 03 Dec 2010
Posts: 3
Location: Portland, OR, USA

PostPosted: Mon Dec 06, 2010 10:56 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message MSN Messenger
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Tue Dec 07, 2010 11:57 am    Post subject: No Undo for Data Reply with quote

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 Smile
Delivery Product Manager
Back to top
View user's profile Send private message
camaro322hp



Joined: 03 Dec 2010
Posts: 3
Location: Portland, OR, USA

PostPosted: Tue Dec 07, 2010 10:10 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message MSN Messenger
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Thu Dec 09, 2010 3:26 pm    Post subject: Suggestion Forum Reply with quote

If you want, you can vote/comment on the "Undo Data" feature suggestion at http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/1281619-undo-data-changes/. We'll update the status on this suggestion once we start working on it.
_________________
Thank you!
Stephanie M. Herr Smile
Delivery Product Manager
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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