Book a Demo

Author Topic: XML import to MySQL database  (Read 5476 times)

andlil

  • EA User
  • **
  • Posts: 24
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
XML import to MySQL database
« on: October 22, 2002, 07:47:26 am »
Hi !

I have tried to migrate an old project from 3.11 into the new
beta using a MySQL database.

I upgraded the project with 3.50 and the I exported the
file to XML. I created a new database and tried to
import the XML file into the new database project.

After some time a dialog showed up with
[-2147217887] and the import failed.

Have anybody got the same problem ?

/Anders

andlil

  • EA User
  • **
  • Posts: 24
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
Re: XML import to MySQL database
« Reply #1 on: October 22, 2002, 08:09:23 am »
Hi again !

I found another way of importing data using the transfer
tool.

It worked much better.

/Anders

gsparks

  • EA User
  • **
  • Posts: 325
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
Re: XML import to MySQL database
« Reply #2 on: October 28, 2002, 05:36:58 am »
Hi Anders,

I believe any problems with the XMI import in EA 350 have now been ironed out for the final release.

In general though you should use the Data Transfer function to upgrade a .EAP file to MySQL or SQL Server. The reason being that the XMI file does not include such things as custom metafiles and images, project specific info and other basic data . XMI import expects a certain amount of backgournd information to be already present.


We also recommend you use the Data Integrity check before upgrading. Failed imports, network crashes and some other early bugs in EA can cause some 'dangling pointers' to diagram links, elements etc. Cleaning these up before upgrading is a good idea - although not essential.


If yuo still experience import problems with the latest build of EA 3.50 - please let us know - and a copy of the offending .xml file is always appreciated,

Cheers,
Geoff Sparks