Kbase P40794: How do I migrate a progress database to a SQL server database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/12/2008 |
|
Status: Verified
GOAL:
How do I migrate a progress database to a SQL server database?
GOAL:
How to convert a progress database to a SQL server database?
FACT(s) (Environment):
Progress 9.1C
Progress 9.1D
MS SQL DataServer
Windows
OpenEdge 10.x
FIX:
The Progress DataServer for SQL Server supports the Progress-to-MSS utility
that allows you to migrate a Progress database. While the DataServer typically makes a data source conform to a Progress database, this utility provides compatibility in the opposite direction. It copies an existing Progress database schema into a target data source.
The Progress-to-MSS utility performs the following tasks:
Creates objects in the target data source
Creates the schema holder and schema image
Optionally populates the data source by dumping and loading the data from
the Progress database
Following these steps to migrate a progress database to a SQL server database
1.Create a target SQL Server. You must use an empty target data source when
you run the Progress-to-MSS utility.
2.Configure your ODBC driver to connect to your new target data source.
3.Start the Progress client and connect to the Progress database that you
want to migrate to the target data source.
4.From the Data Administration tool, choose DataServer> MS SQL Server
Utilities> Schema Migration Tools> PROGRESS DB to MS SQL Server.
You will have to enter following information:
Name of the Original Progress Database
Other connect parameters for Progress Database
Enter name of Schema holder Database
Enter the Logical Database name - the name that Progress will use to
identify the SQL Server database.
Enter name for Database in the ODBC data source - the name you used when
registering the data source.
Enter the Username - the user ID for SQL Server
Enter user's Password - the password of the user.
Enter other connect parameters
Enter codepage for Schema Image
Maximum length of VARCHAR field - Enter the maximum size of the VARCHAR field.
Any size greater will be text. Max size is 8000.
Create RECID field - If this parameter is available for your data source type,
check this toggle box to obtain the Extended 4GL capability.
Load SQL - Leave this box checked to have the generated SQL script loaded into the data source.
Move Data - Check this toggle box to dump and load data from Progress to SQL Server
Create Shadow Columns - SQL Server is case insensitive by default. Leave unchecked unless the default has been changed and you want Progress behavior.
Create Desc Index - SQL Server does not support Descending Indexes. So any indexes that have descending components are skipped. If this box is checked, all indexes are created as ascending.
Include Defaults - Check if you want the Progress initial value used as the default in the SQL script.
Use Fields SQL Width Column - If your Progress database contains data that
is larger than the display format, you can check this toggle box. Change the SQL width field in the Data Dictionary to the proper size. The utility will use the SQL width field instead of the display format.
If you want a complete migration of your Progress database to a target data
source, you must enter information in all appropriate fields and check all appropriate toggle boxes.
The utility creates a schema holder, updates the empty target data source that
you created to contain the objects stored in your Progress database, and creates a startup procedure that you can use to connect your schema holder. The startup procedure derives its name from the logical name for your target database. For example, if you specified "sports" as the logical data source name, the utility creates the csports.p startup procedure.