Multiple Projects under MSSQL

[Doug Blake]

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?

[Geert Bellekens]

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