Kbase P86066: How to migrate a Progress database to MS SQL Server using Progress Utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/14/2006 |
|
Status: Unverified
GOAL:
How to migrate a Progress database to MS SQL Server using Progress Utility
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
The easiest way is to use the Progress to SQL Server utility From Data Administration.
1 Have an existing MS SQL SQL Server Database to load the Progress Schema and eventually data.
2 Configure an ODBC data source to connect to the MS SQL Server Database.
3 Start the Progress client and connect to the Progress database that you want to migrate.
4 From the Data Administration tool, choose DataServer> MS SQL Server Utilities> Schema Migration Tools> PROGRESS DB to MS SQL Server.
5 Fill in the requested information as documented in the Progress manual "Dataserver for Microsoft SQL Server Guide".