Missing Revert

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Missing Revert

Postby Roman » Tue Mar 02, 2010 11:47 pm

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
Roman
 
Posts: 3
Joined: Tue Mar 02, 2010 11:39 pm

Sorry - I see by the redgate.uservoice.com this is WIP

Postby Roman » Tue Mar 02, 2010 11:50 pm

Sorry about that - I'll look through all the postings prior to listing another entry.
Thanks,
Roman
Roman
 
Posts: 3
Joined: Tue Mar 02, 2010 11:39 pm

Missing Revert - Suggestion on redgate.uservoice.com

Postby sherr » Wed Mar 03, 2010 12:41 am

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/390 ... ?ref=title

Thank you!
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Reverting a table

Postby sherr » Wed Mar 03, 2010 4:56 pm

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...
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby Roman » Wed Mar 03, 2010 4:58 pm

It does makes sense. The drop table was probably a poor example of a goof.
Thanks!
Roman
 
Posts: 3
Joined: Tue Mar 02, 2010 11:39 pm


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests