Kbase P94423: How to migrate incremental schema changes from Progress to MS SQL Server?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/16/2010 |
|
Status: Verified
GOAL:
How to migrate incremental schema changes from Progress to MS SQL Server?
GOAL:
How to create a Delta SQL for MS SQL Server?
FACT(s) (Environment):
MS SQL DataServer
OpenEdge 10.x
Windows
FIX:
Starting in 10.0A, the MS SQL Server DataServer Utilities include the Generate Delta SQL option. This utility reads a Progress delta .df and creates a SQL script along with a .df which can be applied to the schema holder.
This utility is under the DataServer->MS SQL Server->Schema Migration-> menu.
For further information see the DataServer Tutorial - Delta df to MS SQL Server incremental schema migration utility in the OpenEdge Microsoft SQL Server DataServer Guide.