Can I put serveral models in one SQL database?

[Dan Moran]

This is probably going to sound like a silly question to long time EA users, but I haven't been able to find the answer in the documentation or here on the forum. The question is...

Can I put more than one model in a single SQL Server 2005 database or do I have to create one SQL Server database for each model? If it's possible to put more than one model in a single database, how is it done?

Any help on this would be appreciated. Thanks.

 - Dan

[Dermot]

Each EA repository does require a seperate Database on the SQL server (however you can have multiple Projects/models within one repository).

[Aaron B]

To add to what Dermot said, the Full Model Data Transfer feature only allows for transfer of one model file into your DBMS repository.  Attempting to transfer a second model file will overwrite the first.  To add a second model into your DBMS repository, you will need to perform an XMI Export from your original model and Import the resulting file into your DBMS repository.

[Geert Bellekens]

To actually add another model you have to right-click on the top level element in the tree and select "New Model (root node)..."