Problem with presql

[Davy Mitchell]

Hi There,

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

Thanks,
Davy Mitchell[/url]

[Chris Auckland]

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.
_________________
Chris

[Jmaharman]

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?

[Brian Donahue]

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 support@red-gate.com.

Thanks!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521