Kbase P24708: Tool for converting/migrating a Progress table definitions to SQL Server or Oracle without using Dat
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/17/2004 |
|
Status: Verified
GOAL:
Tool for converting/migrating a Progress table definitions to SQL Server or Oracle without using DataServer license
GOAL:
Is there a Progress tool that can migrate Progress database definitions to Oracle without using the DataServer product?
GOAL:
Is there a Progress tool that can migrate a Progress database definitions to SQL Server without using the DataServer product?
FACT(s) (Environment):
Oracle
MS SQL
FIX:
Yes, you can generate a sql script for Progress tables through the PRO/SQL menu within the Data Administation. This tool will allow you to select the Progress table(s) and generate two output files, Output File for CREATE TABLE (sports.p) and Output File for CREATE INDEX (sports.i), based on Oracle and SQL Server Databases. Once the output files are created, load them into the foriegn datasource through the foriegn database's client tool such as sqlplus or Query analyzer.