Red Gate forums :: View topic - Problem with presql
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Problem with presql

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Mon Feb 23, 2009 5:25 pm    Post subject: Problem with presql Reply with quote

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.

Shocked

So any ideas? I really don't have to add yet another script to the installer Very Happy

Thanks,
Davy Mitchell[/url]
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Feb 26, 2009 2:20 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Jmaharman



Joined: 28 Sep 2009
Posts: 2

PostPosted: Tue Sep 29, 2009 9:55 am    Post subject: Any updates on this? Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6667

PostPosted: Thu Oct 08, 2009 1:56 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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