Author Topic: import SQLServer ddl script  (Read 3659 times)

klong555

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
import SQLServer ddl script
« 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.


Bruno.Cossi

  • EA User
  • **
  • Posts: 803
  • Karma: +0/-0
    • View Profile
Re: import SQLServer ddl script
« Reply #1 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.



JHUSSAIN

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Import Oracle Schema
« Reply #2 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

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: import SQLServer ddl script
« Reply #3 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.
No, you can't have it!

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: import SQLServer ddl script
« Reply #4 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.)

mhyde

  • EA Novice
  • *
  • Posts: 13
  • Karma: +0/-0
  • EA Convert
    • View Profile
Oracle Packages
« Reply #5 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