Unable to created shared reference repository

[edbridge]

I've attempted to create a shared reference repository.

• -Created DBMS Database

-Initialized as new repository with supplied Sparx Script (successful)
-Open current DBMS MODEL Repository
-Use Project|DataManagement|Shared Repository Dialog.
-- specify path for script
-- enter new DB repository name in Shared Edit control
-- click on generate
GET "[new repository name] is not a valid repository. "  
[/list]
What did I do wrong?
Note: The new reference repository is linked to Sparx as a project. So the name is good.

[smendonc]

I'm pretty sure after creating the new repository you then need to do a transfer from the EABase.eap repository to the new repository before it becomes valid for any further use.

[edbridge]

Thanks for the suggestion but it doesn't help.

After performing the transfer from the EABase.eap in the EA directory, I went through the procedure as above, with the same result.

Also tried with empty db without the initialization. No joy either.

[edbridge]

OK! Enlightenment has been achieved  
It turns out the main repository and the reference repository have to be databases on the same server. This wasn't mentioned in the instructions, and it was not intuitively obvious to me since each has it's own connection string available to sparx.

When I used a main repository on the same server it works just fine.

Now that I see the generated scripts I understand why. One could still achieve the result by linking the two servers, but at the moment it doesn't seem worth the extra effort.

However, I do suggest that Sparx clarify their documentation.

[smendonc]

The line below from the help is where the same server information is ensconced.  At least that's how I interpreted it for SQL Server, though it might need clarification for other DB servers.

[highlight]Shared repositories apply to Database Management System (DBMS) based Enterprise Architect projects and can link all projects residing within one DBMS.
[/highlight]
http://www.sparxsystems.com/enterprise_architect_user_guide/12.0/projects_and_teams/sharedrepositoryrefdata.html

Roy who manages the documentation monitors these threads or you could send a feature request or bug report requesting more clarity in the documentation.

Thanks for posting the resolution!

[edbridge]

Thanks. I've corresponded with Sparx over my confusion. To me, a DBMS is a system, like Oracle, SQL Server, or DB2. Each of those may reside on one or many servers. What, I believe, was meant, was that the repositories must reside on the same server.