Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: klong555 on March 29, 2006, 03:27:42 pm

Title: import SQLServer ddl script
Post by: klong555 on March 29, 2006, 03:27:42 pm

newbie here - I can't figure out how to reverse engineer/import a DDL script for SQLSERVER.

thank you.

Title: Re: import SQLServer ddl script
Post by: Bruno.Cossi on March 29, 2006, 03:57:00 pm

Hi,

short answer - you can't. It has been discussed several times on the forum, if you search for "DDL", you will find that you are not the only who has been asking for it.
You can not reverse engineer DDL script, but you can reverse engineer a schema, so a simple workaround would be the execute the script and import the resulting structures.

Hope this helps!
Bruno

Quote

newbie here - I can't figure out how to reverse engineer/import a DDL script for SQLSERVER.

thank you.

Title: Import Oracle Schema
Post by: JHUSSAIN on September 26, 2006, 02:17:16 pm

When the Oracle Schema was imported, it does show only the TABLES and standard Stored Proceudres. It does not list the Procedures /Fuctions in the Packages.
How can i import Oracle Packages  into Data  model.

Thanks
Jaheer

Title: Re: import SQLServer ddl script
Post by: «Midnight» on September 26, 2006, 02:24:36 pm

If you mean packages in the sense of Oracle stored procedures, you are still out of luck... At least for a while. The whole idea of importing stored procedures has been discussed from time to time.

My (completely uneducated) impression is that Sparx is looking at this as a possible feature in future releases.

Perhaps one of the Sparxians would care to shed light on this.

Title: Re: import SQLServer ddl script
Post by: hd on October 01, 2006, 03:32:41 pm

Sparx is definitely looking at this as a possible feature in future releases. (We do not have a release date as yet.)

Title: Oracle Packages
Post by: mhyde on April 19, 2007, 06:52:57 am

Hi,
Any more news on when the ability to handle Oracle packages might be introduced?
TIA
Malcolm