Competition: What’s your favorite Redgate tool? Enter now.

Creating new database fails (Object already exists)

pashapasha Posts: 7
edited June 13, 2008 6:04AM in SQL Packager Previous Versions
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

Comments

  • Eddie DEddie D Posts: 1,688 Rose Gold 5
    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 [email protected]
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.