how to convert repository form mysql to mssql?

[dindeck]

I have a medium sized (7MB) EA database that is currently in MySQL and running fine.  I would like to be able to turn over a copy to another party to be run on Microsoft SQL Server.  How could I convert?  I have been trying two main approaches, but I am unsuccessful so far.
1) I exported from MySQL to XML and tried to import to the MS-SQL repository.  But I got lots of errors about the "file format" and "UML" immediately.
2) I did a mysqldump using --compatible=mssql.  But the output file has numerous errors immediately upon trying to run into my MS-SQL repository.  Many syntax errors that are so numerous, I feel I am not taking the right approach.
Any ideas?
Thanks.

[«Midnight»]

Try using Tools / Data Management / Data Transfer and check the DBMS to DBMS option. Please let us know if that works.

I'm a little curious about these errors. Perhaps you should first run Tools / Data Management / Data Integrity Check to see if there are problems in your project.

You might also want to look at the Tools / Diagram / Strict UML Syntax setting. Is there a chance you have this checked for a project where it was not required (or followed in any case)?

[dindeck]

Yep...I was able to successfully convert to Microsoft using the "Tools / Data Management / Data Transfer " utility.  My first attempt was with an intermediate *.EAP file, but I don't think the intermediate *.EAP will really be necessary in the long run.  Thanks lot for your help!!!!

[«Midnight»]

Excellent!

I like to keep an empty - really empty, which requires some determined 'pruning' of entries by hand - EAP file. I use this to bootstrap empty DBMS files.

Once you've got one of these in a DBMS you can do the same thing at that level. The empty DBMS file can be quickly used as a startup project, and can be easily shared.

In your case you could experiment with transfers between different DBMS engines. This trick might make your life a bit easier.

HTH, David