Export Progress database

R

redlyon13

New Member
I need obtain de ER model of a database, I have the soft CASE Studio but this software not support a progress database, for this I need export my DB to MS SQL Server, but I dont Know how do it this, y generate a file "personal.sql" using a menu DATASERVER > MS SQL Server Utilities > Schema Migration Tools > PROGRESS DB TO MS SQL SERVER, when I run this query in MS SQL, the tables are created but the index and relation not , how i can do it ?
Sorry I'm newbie :o

Thank's for your help
 
Are your Progress DB tables correctly built utilizing primary and foreign key references?

That is, if you have the primary key 'CustNum' in the Customer table, do you have an exact reference to that same field 'CustNum' in your 'Order' table -- and does it appear in an Index?

If you are setup correctly, then you may want to look into setting the Progress DB with SQL92 access. You could probably then use your CASE tool to extract the tables/fields/indexes/relationships via that method.

I wouldn't use the SQL table generation routines .... they are typically lacking.
 
As Progress does not support foreign keys, it's typically a hard job extracting relational data -- because there is none!

See this discussion at the OpenEdge Hive: http://www.oehive.org/node/1161

If you'd like the script mentioned in my post just let me know.
 
You must log in or register to reply here.
Back
Top