Kbase P111448: How to dump and load SQL-92 schema and data?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/03/2008 |
|
Status: Verified
GOAL:
How to dump and load SQL-92 schema and data?
GOAL:
What are the steps involved in dumping and loading SQL-92 objects data definition and data?
GOAL:
How to use the SQLSCHEMA Utility to dump the schema of SQL-92 tables and/or SQL-92 Views from the source database.
GOAL:
SQL-92
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
FIX:
The steps involved in dumping and loading both the schema and data of the Progress SQL-92 tables:
1. Use the SQLSCHEMA Utility to dump the schema of SQL-92 tables and/or SQL-92 Views from the source database. For example:
sqlschema -o myOutputFile -t %.% -u yshanshi -a yshanshi progress:T:pcyshanshi:9999:sports2000
2. Use the SQL Explorer Tool to load the schema of SQL-92 tables from file(s) created using the SQLSCHEMA Utility into the destination database. For example:
sqlexp -user yshanshi -password yshanshi -db sports2000 -H pcyshanshi -S 9999 -infile myOutputFile.dfsql
3. Use the SQLDUMP Utility to dump the data from of SQL-92 tables from the source database. For example:
sqldump -t %.% -u yshanshi -a yshanshi progress:T:pcyshanshi:9999:sports2000
4. Use the SQLLOAD Utility to load the data of SQL-92 tables from files created using the SQLDUMP Utility into the destination database. For example:
sqlload -t YSHANSHI.MYTABLE -u yshanshi -a yshanshi progress:T:pcyshanshi:9999:sports2000