Reversing a script

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Reversing a script

Postby aultmike » Mon Mar 01, 2010 3:22 pm

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
aultmike
 
Posts: 26
Joined: Fri Jan 08, 2010 3:49 pm
Location: Canton, OH

Postby Chris Auckland » Tue Mar 02, 2010 9:58 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby aultmike » Tue Mar 02, 2010 10:01 pm

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!
aultmike
 
Posts: 26
Joined: Fri Jan 08, 2010 3:49 pm
Location: Canton, OH


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests