adding script in the middle of upgrade script

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

adding script in the middle of upgrade script

Postby goldman75100 » Mon Sep 05, 2011 9:44 am

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?
goldman75100
 
Posts: 3
Joined: Mon Sep 05, 2011 8:14 am

Postby David Atkinson » Mon Sep 05, 2011 10:15 am

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby goldman75100 » Mon Sep 05, 2011 3:14 pm

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
goldman75100
 
Posts: 3
Joined: Mon Sep 05, 2011 8:14 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests