adding script in the middle of upgrade script

goldman75100

Hello there

One of the users has added new fields to an existing table. he also add unique index based on that keys, and he gave me script to fill the new field with data.

The upgrade script should do the following:

1. Add field
2. Update new field
3. Add index

How can i add the update script to Packager between the add field and the add index?

David Atkinson

The only way to do this currently is to take the script output from SQL Packager, modify it and to import it back in to SQL Packager.

Do let us know if this approach won't work for you.

David Atkinson
Product Manager
Red Gate Software

goldman75100

David Atkinson wrote:

The only way to do this currently is to take the script output from SQL Packager, modify it and to import it back in to SQL Packager.

Do let us know if this approach won't work for you.

David Atkinson
Product Manager
Red Gate Software

If i'm using the packager to create script and then create package based on that script it gives me errors: your SPlit action on c# does not apply all cases of GO