Red Gate forums :: View topic - Creating new database fails (Object already exists)
Return to www.red-gate.com RSS Feed Available

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

Creating new database fails (Object already exists)

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
pasha



Joined: 28 May 2008
Posts: 4
Location: Mt. View, CA

PostPosted: Tue Jun 10, 2008 7:29 pm    Post subject: Creating new database fails (Object already exists) Reply with quote

Good Morning!

Not sure if it is a bug or an option to be turned on or off. When database is being deployed to a server, it fails with the message that the object already exists (stored procedure). This stored procedure is in both, the original database and the model database on the destination server. So, when the new database is created, the stored procedure is created automatically (from model); then, the Packager tries to create that stored procedure again (from the script).

I know I can de-select the stored procedures when packaging the database, but it is very inconvenient, as I have to do it on many databases. A feature of dropping if exists would be very useful.

Thanks,

Pasha
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Fri Jun 13, 2008 11:04 am    Post subject: Reply with quote

Thank you for your post into the forum. and for your suggestion.

The feature you are looking for is not currently available in SQL Packager.

I have submitted a feature request for the development team to consider adding a new feature - IF EXISTS DROP.

Unfortunately I cannot guarantee that the request will obtain approval and if approval is given, what future version of SQL Packager the feature will appear in.

Many Thanks
Eddie

Eddie Davis
Product Support Engineer
Red Gate Software Ltd
E-Mail support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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