Red Gate forums :: View topic - adding script in the middle of upgrade script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

adding script in the middle of upgrade script

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
goldman75100



Joined: 05 Sep 2011
Posts: 3

PostPosted: Mon Sep 05, 2011 9:44 am    Post subject: adding script in the middle of upgrade script Reply with quote

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?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Mon Sep 05, 2011 10:15 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
goldman75100



Joined: 05 Sep 2011
Posts: 3

PostPosted: Mon Sep 05, 2011 3:14 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group