Book a Demo

Author Topic: Compare database  (Read 12456 times)

Benrath

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Compare database
« Reply #15 on: November 19, 2020, 07:15:05 pm »
So i finally a simple solution, just c&p my answer from Stack Exchange

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.
https://stackoverflow.com/questions/19481324/how-do-you-set-the-database-schema-at-the-package-level-in-sparx-enterprise-ar

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.