Competition: What’s your favorite Redgate tool? Enter now.

Reversing a script

aultmikeaultmike Posts: 43
edited March 2, 2010 4:01PM in SQL Packager Previous Versions
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

Comments

  • 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, 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!
Sign In or Register to comment.