Book a Demo

Author Topic: Import from legacy database  (Read 2994 times)

Rudi Claes

  • EA Novice
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Import from legacy database
« on: March 22, 2012, 12:34:05 am »
I've got a legacy database with a lot of content I need to migrate to Sparx. Import via XMI should then be the path to follow. Leads to a conversion from that relational data to XMI. I'm considering the usage of XSLT or SSIS (SQL Server Integration Services). Has anyone got experience with this? Are there other scenarios to consider?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Import from legacy database
« Reply #1 on: March 22, 2012, 01:13:17 am »
Rudi,

I wouldn't start creating XMI manually.
The first option is to to use the ODBC reverse engineering.
If that doesn't work out I would use some other kind of import mechanism  like the simple vba excel importer

Regards

Geert

PS. Call or email me privately if you want to discuss more.