Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: bockfu on September 07, 2016, 06:49:31 am

Title: DBMS based Project Transfer for 12.1
Post by: bockfu on September 07, 2016, 06:49:31 am

I am using EA 12.1.1230 with SQL DBMS as repo.

I want to transfer to another SQL DBMS instance.

The Team Modeling Resources for Enterprise Architect page at http://www.sparxsystems.com/resources/corporate/index.html only provides links for 13.0 schema:

http://www.sparxsystems.com/downloads/corp/scripts/EASchema_1220_SQLServer.sql

I created database with scripts cited above.
When transferring form DBMS to DBMS, I get errors comparable to "Cannot find the object "t_category" because it does not exist or you do not have permissions."

When I run the 'Project Compare...' option, unexpected differences are cited.

Are there 12.1 EASchema scripts I should be using instead of those based on 13.0?   If so, where/how do I get them?

Title: Re: DBMS based Project Transfer for 12.1
Post by: qwerty on September 07, 2016, 07:33:57 am

I guess this schema is still valid and it contains the table t_category. So most likely you see a permission problem. Try a user with full permissions first (grant RWUD is enough though).

q.

Title: Re: DBMS based Project Transfer for 12.1
Post by: Eve on September 07, 2016, 08:17:00 am

The schemas listed on the website are fully compatible with 12.1.

SQL Server requires an additional permission to perform a database transfer. I can't remember what the permission is called, only that it is needed for resetting the auto-number columns.

Title: Re: DBMS based Project Transfer for 12.1
Post by: bockfu on September 07, 2016, 08:38:47 am

@Simon

SQL has the following 'Fixed-Database Roles':  https://msdn.microsoft.com/en-us/library/ms189121.aspx

Any one of those ring a bell?

I have db_datareader and db_datawriter.

Title: Re: DBMS based Project Transfer for 12.1
Post by: Eve on September 07, 2016, 08:54:50 am

db_ddladmin sounds like the only one that would fit.

Title: Re: DBMS based Project Transfer for 12.1
Post by: Geert Bellekens on September 07, 2016, 12:47:41 pm

Quote from: Simon M on September 07, 2016, 08:54:50 am

db_ddladmin sounds like the only one that would fit.

I can confirm that, something to do with the ability to "drop or truncate" stuff I think, but I never got to the bottom of it.
Of course db_admin always works as well. :)

Geert

Title: Re: DBMS based Project Transfer for 12.1
Post by: bockfu on September 08, 2016, 06:32:41 am

double confirmation complete.

Once db_ddladmin role was added I was able to transition SQL based DBMS with no errors or differences to original DBMS.

Thank you,
-Steven