Compare database

[Benrath]

I am very new to EA and in general data engineering. I want to be able syncronize my MS SQL DB with the data model I created in EA. Using the help and tutorials, I learnt how to push my data model onto the MS SQL DB. What I fail to achieve is the syncronization. I have a feeling that is has to do with the schema. The database builder lists all the orginal tables and then again all tables from the ODBC connection with an additional 'dbo.'

Do i need to define this somwhere in the options of my data model or can I compare the data model with the server taking account of the schema?

I also posted this question on SO, to be able to include a picture.
https://stackoverflow.com/questions/64205609/enterprise-architect-compare-database

[pvickers]

Hi - Welcome to the forum.

You need to work in the “Database Builder” feature of Sparx EA. 

This can be found on the "Develop" tab.  (This will not work directly from the “Browser”) - Select the package having the “Database” as it’s stereotype.  Use mouse button 2 and select “Manage DBMS Options”.  The dialog will enable you to change the table(s) owner or even change the selected DBMS type.  From the database builder you can then perform the "database compare" or "compare with options".

Note regarding terminology - the "dbo" in SQL Server is a the database owner.

Hope this helps.

[Benrath]

Hi and thanks, also for the feedback.

Sadly I am working in a localized version in Germany, so I need to translate back. I found the option "Datenbankbilder" (which is a bad translation for "database Builder") that has the same ribbons in englisch that should be there. For instance i can use the SQL Scratch Pad to query a table that I changed on the server, e.g. renamed a column.

On the left hand side, I have one object <<Database>> SQLServer2012 which seems to be my local data model. Using the mouse button 2 load/unload, Import DB scheme from OBDC, show differences, Properties, Find, refreseh.

Not sure if Properties should be "Manage DBMS Options". I read about the Compare with options function, but I cant find it.


If it helps I could add more screenshots.
Do i need to set an owner for each table in the data model?

I created the data base using the "generate DDL" option directly onto the server.

[pvickers]

Not sure if Properties should be "Manage DBMS Options". I read about the Compare with options function, but I cant find it.

The Properties option is different from "Manage DBMS Options".  You will only see the "Manage DBMS Options" if you have the correct object type selected on the list.  For example, it should have a stereotype of "Database".
(By way, I'm currently running Sparx EA version 15.1 build 1529.)

The table owner and schema are important to set correctly for the comparison process to be able to match the tables.

Note, in the comparison results you can also tell EA to match tables.
You may find more information on this here: (This references the version 15.2 documentation)
https://www.sparxsystems.com/enterprise_architect_user_guide/15.2/model_domains/import_schema_into_builder.html

Perry

[Benrath]

There might be one reasons for the problem. Apperently my "company" uses Version 11.1.1113  Build 1215.

All I see is this:


If i go into properties I see this. Can I change the option there?

[qwerty]

Boah, wie einst bei Siemens xD

I'd try Eigenschaftten from the Context menu of Datenbankbilder (mannomann, wer hat das übersetzt?)

q.

[Benrath]

Not Siemens, I work for the very slow team that supposedly manages the country.

Anyhow I found this.
and I actually already includes dbo as the default owner.



What else can I do?

[qwerty]

Not a big difference then ;-)

As said on SO I can't really help with the database builder. If nothing/nobody helps you can also mail Sparx ([email protected]) directly.

q.

[Uffe]

(mannomann, wer hat das übersetzt?)

Ich denke Google. Oder vielleicht ein Gymnasium Schüler mit einer schweren Gehirnerschütterung. 

/U

[Geert Bellekens]

(mannomann, wer hat das übersetzt?)

Ich denke Google. Oder vielleicht ein Gymnasium Schüler mit einer schweren Gehirnerschütterung. 

/U

I suppose that should be the guys from LieberLieber/Sparx CE in Wien

Geert

[qwerty]

Might be (they sell the German translation, don't they?). I won't start repeating jokes about German/Austrian relations, but... Strange enough that people buy translated SW where most of the terminology used inside is English anyway.

q.

[Geert Bellekens]

Might be (they sell the German translation, don't they?). I won't start repeating jokes about German/Austrian relations, but... Strange enough that people buy translated SW where most of the terminology used inside is English anyway.

q.

Yeah, depends largely on culture. I don't think there would be anyone interested in a Dutch version here in Belgium.
Me personally I have all of my software in English, much easier if you have to follow instructions found on the web.

In France however

Geert

[Benrath]

Love how this sparxed a discussion, pun intended.

Any ideas how i can resolve my problem ?

[Geert Bellekens]

Love how this sparxed a discussion, pun intended.

Any ideas how i can resolve my problem ?

I can't reproduce your issue, so it's hard for me to suggest solutions.

You have two options I see

- upgrade to the latest version and see if it's still a problem htere
- contact Sparx support (send a bug report using the link https://www.sparxsystems.com/support/forms/bug_report.html)

Geert

[qwerty]

See my post above about mailing Sparx.

q.