Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Doug Blake on November 24, 2011, 01:26:36 am

Title: Multiple Projects under MSSQL
Post by: Doug Blake on November 24, 2011, 01:26:36 am

We created a project in our sql repository by TRANSFERing in from an eap file. However each transfer overwrites the previous project. While we only have one active project at the moment, we will need more and my questions are:

Will an SQL repository store more than 1 project?
And if so, how do I get data for the 2nd project into the repository?

Title: Re: Multiple Projects under MSSQL
Post by: Geert Bellekens on November 25, 2011, 05:13:31 pm

It actually doesn't matter if it's a DBMS or plain old eap (MS Access) file. Both have the same database structure and the same possibilities regarding multiple projects.
Project transfer should maybe better be named "database transfer" as it transfers a database from one format to another.
So if you had separate databases for each project when using eap file you'll have separate databases when using MS SQL Server.

Now if you want to combine several databases into a single database (eap or DBMS alike) you'll have to use xmi import/export.

Geert