adding script in the middle of upgrade script

goldman75100goldman75100 Posts: 5
edited September 5, 2011 10:14AM in SQL Packager Previous Versions
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?

Comments

  • 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
    David Atkinson
    Product Manager
    Redgate Software
  • 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
Sign In or Register to comment.