| Author |
Message |
goldman75100
Joined: 05 Sep 2011
Posts: 3
|
 Posted: Mon Sep 05, 2011 9:44 am Post subject: adding script in the middle of upgrade script |
 |
|
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 |
|
 |
David Atkinson
Joined: 05 Dec 2005
Posts: 1079
|
| Posted: Mon Sep 05, 2011 10:15 am Post subject: |
|
|
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 |
|
|
goldman75100
Joined: 05 Sep 2011
Posts: 3
|
| Posted: Mon Sep 05, 2011 3:14 pm Post subject: Re: |
|
|
| 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 |
|
|
|
|
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
