Red Gate forums :: View topic - Reversing a script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Reversing a script

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
aultmike



Joined: 08 Jan 2010
Posts: 26
Location: Canton, OH

PostPosted: Mon Mar 01, 2010 3:22 pm    Post subject: Reversing a script Reply with quote

I was unaware that the script the SQL Packager creates doesnt include the creation of the database... as such I just ran it and injected everything into the master database... is there anyway I can reverse this?

Thanks
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Mar 02, 2010 9:58 pm    Post subject: Reply with quote

I'm afraid there isn't any way to undo the execution of the script.

Your only options are to drop all the objects created on the master database, or to restore the master database from backup.

The creation of the database is part of the SQL Packager executable, the scripts it creates are just for the schema and the data.

Sorry I can;t be of more help.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
aultmike



Joined: 08 Jan 2010
Posts: 26
Location: Canton, OH

PostPosted: Tue Mar 02, 2010 10:01 pm    Post subject: Reply with quote

Chris, thanks for the reply. What i ended up doing was using SQL Compare *wink* to compare the master database in question with the master database on another server... I figured the structure of them should be close... and it did the trick.

I created a syncronization script to delete the things that didnt match.

Thanks again!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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