Kbase P102237: When migrating a Progress database with primary unique indexes, no primary key constraints are creat
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/07/2009 |
|
Status: Verified
SYMPTOM(s):
When migrating a Progress database with primary unique indexes, no primary key constraints are created into the foreign database.
Protoora does not create primary keys in Oracle database
Protomss does not create primary keys in MS SQL database
No primary key constraints are created when generating SQL CREATE TABLE statements from the PRO/SQL option in the Data Administration.
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.0x
MS SQL DataServer
ODBC DataServer
Oracle DataServer
CAUSE:
Enhancement request# OE00159850
FIX:
This enhancement has not been implemented in the product.
You can use 3rd-party software in order to achieve this:
Use the CREATE TABLE wizard or the Data Export wizard (only in the professional version) from WinSQL. A free version can be downloaded at:
http://www.indus-soft.com/SynametricsWebApp/WinSQL.jsp
- OR -
For MS SQL Server use the following method:
- Create Linked Tables to the Progress database via ODBC within MS Access.
- Then use the Access Upsizing Wizard to export the tables to a SQL Server database.
- Check the Access help files and the Microsoft Knowledgebase at http://support.microsoft.com/search/?adv=1 for further details.