DBMS based Project Transfer for 12.1

[bockfu]

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?

[qwerty]

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.

[Eve]

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.

[bockfu]

@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.

[Eve]

db_ddladmin sounds like the only one that would fit.

[Geert Bellekens]

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

[bockfu]

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