Search code examples
databaseenterprise-architectdatamodel

Enterprise Architect Compare database

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?

enter image description here

Solution

  • I needed to add the owner tag dbo to all my tables. For some reson it was not enough to add it to the data model object. Thanks to this thread i found an option to change it for all tables at once. How do you set the database schema, at the package level, in SPARX Enterprise Architect?

    There were still some differences about the PK and FK ids when i tried to compare but I just aligned my local data model with that and now there are no differences between the data model and the data base.