Kbase P62514: How to generate SQL CREATE TABLE/INDEX statements/scripts for Progress from Progress Meta Schema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/14/2005 |
|
Status: Verified
GOAL:
How to generate SQL CREATE TABLE/INDEX statements/scripts for Progress from Progress Meta Schema
GOAL:
How to generate SQL CREATE TABLE/INDEX statements/scripts for Oracle from Progress Meta Schema
GOAL:
How to generate SQL CREATE TABLE/INDEX statements/scripts for MS SQL Server from Progress Meta Schema
FIX:
Follow these steps to generate SQL CREATE TABLE/INDEX statements from an existing Progress, Oracle or MS SQL database.
1. In either the Character Data Dictionary or Data Administration tool, choose PRO/SQL-> Dump as CREATE TABLE Statement. Progress alphabetically lists all the tables defined for your database.
2. Select a table or type ALL for all tables to be generated.
3. Specify the output filenames for the CREATE TABLE and CREATE INDEX statements. If you do not specify a filename for the CREATE INDEX statement, Progress writes the CREATE INDEX statement to the CREATE TABLE statement output file.
4. Select the SQL-flavor. If you select Oracle or MS SQL Server, select to create 4GL compatible objects and/or to use the _width column for the size of the field.
5. Choose OK to generate the file.
The files generated will contain the SQL to generate the schema. If you have selected to create 4GL compatible objects, all objects necessary for this such as the progress_recid field are also created.
NOTE:
Any existing primary keys will be stripped from the SQL statements. Enhancement request# 20040604-017 has been logged.