Import Database Schema from SQL Server 2008R2 using EA14

[skiwi]

I'm trying to import a Database Schema from SQL Server 2008R2.

I get the message ERROR: retrieving  sequence list  -  [S0002]: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.SEQUENCES'.

I am told that "INFORMATION_SCHEMA" is a built-in SQL Server schema holding metadata views. The SEQUENCES view does not exist in versions older than SQL Server 2012


Is there a way I can tell EA14 to correctly import the schema?


[See http://www.sparxsystems.com/enterprise_architect_user_guide/14.0/model_domains/importdatabaseschemafromod.html]

[banidja]

Hi!

Did you manage to find workaround? I'm getting every time I want to transfer file to DBMS a set of errors: invalid object: (u)sys***

I read about database builder but I simply don't get any create or load data model option..

I just want to have store with diagrams so that my colleagues and I can easily access to each other diagrams and be able to edit! So I need file storage, I have no intention to make any queries when the .eap(x) file get to the Microsoft SQL server database.
I repeat: the only goal is to have ability to open eap file that is located on the server (not cloud) - and I have created database and ran the script from resources on the sparxsystems - DBMS repository scripts.

[Geert Bellekens]

I think you should start a different thread, and add all relevant details.
You seem to be having a completely different problem.

Geert