| Author |
Message |
aultmike
Joined: 08 Jan 2010 Posts: 25 Location: Canton, OH
|
Posted: Mon Mar 01, 2010 3:22 pm Post subject: Reversing a script |
|
|
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 |
|
 |
Chris Auckland
Joined: 24 Oct 2006 Posts: 710 Location: Red Gate Software Ltd.
|
Posted: Tue Mar 02, 2010 9:58 pm Post subject: |
|
|
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 |
|
 |
aultmike
Joined: 08 Jan 2010 Posts: 25 Location: Canton, OH
|
Posted: Tue Mar 02, 2010 10:01 pm Post subject: |
|
|
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 |
|
 |
|
|
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