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
I was following the tip put up by Red Gate here
to reinstall a database.
However the presql script is NOT run if the supplied database name already exists. My plan was was to use presql to backup and drop any exisiting DB. Frustratingly presql seems incapable of doing this.
So any ideas? I really don't have to add yet another script to the installer
- Posts: 14
- Joined: Wed Oct 15, 2008 2:41 pm
- Location: Scotland
Thanks for your post.
I think this can be classed as a bug with SQL Packager 6. The pre SQL Script should have a chance to run before the package validates if the database already exists or not.
I've now logged this in our development database under the code SPA-513.
Once it has been reviewed by the developers, we can let you know if/when it will be fixed.
Thanks for letting us know about this.
- Posts: 757
- Joined: Tue Oct 24, 2006 2:12 pm
- Location: Red Gate Software Ltd.
Have there been any updates on this? I don't want to delete and backup the DB I just want to leave the DB in place and run the scripts over it?
- Posts: 2
- Joined: Mon Sep 28, 2009 4:26 pm
The issue with "/presql" scripts has been addressed internaly, and we have a private, untested build available. If you need the update for this reason, please contact email@example.com
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Packager 6
Who is online
Users browsing this forum: No registered users and 0 guests