Kbase 20697: How to transfer data and schema which was originally created with SQL92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to transfer data and schema which was originally created with SQL92
FACT(s) (Environment):
Progress 9.x
UNIX
Windows
FIX:
When tables are created using SQL92 they can not be accessed via a 4GL client connection. In order to dump the data from a SQL92 table and load it back into the Progress database(as a 4GL table), the normal Data Dictionary or Data Administrator dump and load utilities can not be used.
To accomplish this task, you must use the Progress SQLDUMP command line utility to dump the SQL92-created table data. In turn, the SQLDUMP utility can not dump 4GL table data. This must be done using the Data Dictionary or Data Administrator dump and load utilities.
To load the data generated from the SQLDUMP utility, use the Progress SQLLOAD command line utility.
Additionally, the SQLSCHEMA command line utility can be used to selectively write SQL92 database schema to an output file. This allows you to capture table definitions (including constraints, views, stored procedures, related privileges and triggers).
Finally, to load SQL92 database schema into a Progress 9.x database, use the Progress SQL Explorer utility.