Red Gate forums :: View topic - Missing Revert
Return to www.red-gate.com RSS Feed Available

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

Missing Revert

Search in SQL Source Control 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
Roman



Joined: 02 Mar 2010
Posts: 3

PostPosted: Tue Mar 02, 2010 11:47 pm    Post subject: Missing Revert Reply with quote

Hi,
Sorry if I missed this, but if I have a linked DB, create objects, checkin, so all objects are at version 1. Within SSMS, I drop table "keywords", so SubVersion has dbo.keywords.sql, but the DB does not.

Now I realize the error of my ways and want to revert the dropped table - how do I do this?

Thanks!
Roman
Back to top
View user's profile Send private message
Roman



Joined: 02 Mar 2010
Posts: 3

PostPosted: Tue Mar 02, 2010 11:50 pm    Post subject: Sorry - I see by the redgate.uservoice.com this is WIP Reply with quote

Sorry about that - I'll look through all the postings prior to listing another entry.
Thanks,
Roman
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Wed Mar 03, 2010 12:41 am    Post subject: Missing Revert - Suggestion on redgate.uservoice.com Reply with quote

Hi Roman,

No problem. I'm glad you were able to find this on our Suggestion Forum. We are currently working on the Revert functionality. If this is important to you, you can comment/vote at http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/491513-revert-undo-pending-change?ref=title

Thank you!
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Wed Mar 03, 2010 4:56 pm    Post subject: Reverting a table Reply with quote

One more thing that I wanted to mention... In this example, you want to revert/undo a dropped table. In a future SQL Source Control version, you will be able to do this, but it will only bring back the table's schema and not the data that was in the table. Does that make sense?

SQL Source Control is not a replacement for database backups. After reverting the schema, you could use our SQL Data Compare to synchronize the data in that table from a recent backup or from another dev/test/production db. Since it's a development db, you may not be concerned about the data anyways.

In a future version of SQL Source Control, we are considering giving users the option to also source control data. This would be useful for static/reference/lookup data that is part of the application and not really recommended for transactional data. If this data was in source control, then this should be revertable as well. This is a ways out right now...
Back to top
View user's profile Send private message
Roman



Joined: 02 Mar 2010
Posts: 3

PostPosted: Wed Mar 03, 2010 4:58 pm    Post subject: Reply with quote

It does makes sense. The drop table was probably a poor example of a goof.
Thanks!
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