Alter Table and Package Data?
Neil Davidson
Posts: 281
Hayato,
The way round this is to do it in three steps. First of all, create a
package that will upgrade the schema of the update. Then create a database
which has the correct schema but the old data. You can then use SQL Packager
to create a second package to upgrade the data.
Yours,
Neil Davidson
Red Gate Sofware Ltd
"Hayato Iriumi" <hiriumi@hotmail.com> wrote in message
news:w3uVvJVkEHA.2744@server53...
> I have three tables that are going to be altered and then I want the data
of
> those tables to be packaged too. It seems that SQL Packager can't do it
> right now? Is there any solution for this?
>
>
The way round this is to do it in three steps. First of all, create a
package that will upgrade the schema of the update. Then create a database
which has the correct schema but the old data. You can then use SQL Packager
to create a second package to upgrade the data.
Yours,
Neil Davidson
Red Gate Sofware Ltd
"Hayato Iriumi" <hiriumi@hotmail.com> wrote in message
news:w3uVvJVkEHA.2744@server53...
> I have three tables that are going to be altered and then I want the data
of
> those tables to be packaged too. It seems that SQL Packager can't do it
> right now? Is there any solution for this?
>
>
- Neil Davidson
Red Gate Software Ltd
Red Gate Software Ltd
This discussion has been closed.
