Comments
7 comments
-
Thank you very much for the Static Data feature, we appreciate it! -
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. -
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. -
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 - 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! -
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.
-
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.
Add comment
Please sign in to leave a comment.
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.