Dropping objects before create

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Dropping objects before create

Postby bpye » Tue Mar 27, 2007 2:32 pm

Is there any way to generate a package that will check for existence of database objects and drop them if they exist, before creating them?
bpye
 
Posts: 3
Joined: Tue Mar 27, 2007 2:28 pm

Postby Brian Donahue » Tue Mar 27, 2007 9:23 pm

Hi,

Unfortunately not. New database packages shouldn't need this logic, and upgrade packages attempt to modify and adjust existing objects.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby bpye » Tue Mar 27, 2007 9:31 pm

Thanks for the reply. Will any of the Red Gate tools generate IF EXISTS...DROP... scripts for objects I select?
bpye
 
Posts: 3
Joined: Tue Mar 27, 2007 2:28 pm

Postby bpye » Wed Mar 28, 2007 4:58 pm

In case anyone is interested, I ended up generating DROP script by configuring SQL Packager to upgrade to an empty database.
bpye
 
Posts: 3
Joined: Tue Mar 27, 2007 2:28 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests