Kbase P12854: How to create Microsoft SQL Server Database from a Progress Database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/12/2009 |
|
Status: Verified
GOAL:
How to create Microsoft SQL Server Database from a Progress Database?
GOAL:
How to create MS SQL script for the tables and indexes for the SQL Server Database?
GOAL:
How to transfer the progress data definitions t to the SQL Server Database?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
MS SQL Server
FIX:
The following steps are needed to create a MSSQL database from a Progress Database
1) Connect to the Progress database that needs to be loaded into the MS SQL Server Database.
2) Start a DBAdmin session -> PRO/SQL -> Dump As Create Table Statement -> (REPEAT for each Table required)
- Select Table required
- accept default "Output File for CREATE TABLE" (table.p)
- accept default "Output File for CREATE INDEX" (table.i)
- SQL-Flavor = MS SQL Server
- Generate PROGRESS-Compatible Schema = TRUE
- Use Sql Width Definition = TRUE (if you want to have more data then the display format of that is set in the Progress Data Dictionary)
- OK (message: Output completed)
NOTE: <table>.p and <table>.i have now been created
3) Start a MS SQL Query Analyser session
- Choose the SQL Database (msql.db)
- Open Script for table.p and table.i
- Parse table.p and table.i and correct inconsistencies:
(for example: table.p may have an "exit" that is not needed and can be deleted)
- Execute