Bringing in a SPARX model into SQL

[Nosipho]

Hello people,

Is there a way to bring in a SPARX model into SQL??

[Geert Bellekens]

Project|Data Management|Project Transfer
(if that is what you are asking )

Geert

[Nosipho]

Yes thank you, but now I'm getting the "Error -2147217865 "Invalid Object name '#<table name>' " error , how can I handle this because I tried to search what the cause is and how to deal with it but the answers are rather vague

[Geert Bellekens]

Have you created the database structure before trying to transfer?

Geert

[Nosipho]

I created a database, is my target project supposed to have the same structure as my source project??

[Aaron B]

Perhaps watch the following webinar video.  The first several minutes walks through the process of creating a new MySQL database, creating the table structure and then performing the initial data transfer.
http://www.sparxsystems.com/resources/demos/team-modeling/setting-up-a-team-modeling-environment.html

Steps may vary slightly depending upon the specific database type you are working with, but refer to the EA help for more specific instructions.
http://www.sparxsystems.com/enterprise_architect_user_guide/12.1/the_model_repository/settingupdatabasemodelfile.html

SQL scripts for creating the required table structures on each supported DBMS can be found here:
http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts