What are the challenges you face when working across database platforms? Take the survey
Options

Possible to ignore object owner when comparing?

StevenMStevenM Posts: 3 Bronze 1
edited December 6, 2012 3:43PM in SQL Compare Previous Versions
Hi guys

We have a few different databases for our JD Edwards environment (DEV, QA, PROD, etc). The databases are exactly the same with the exception of the object owner. For instance, in DEV, a table may be called something like TESTCTL.F0002 but in PROD it's called PRODCTL.F0002. Is there a way to tell SQL Compare to ignore the object owner when making comparisons?

Tks

Comments

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi

    Thank you for your forum post.

    Unfortunately you cannot ignore the object owner. However you can edit the SQL Compare project ->Select the Owner Mapping Tab ->Map the DEV object owner, TESTCTL to the PROD PRODCTL object owner.

    Also you can map the tables together, so in the DEV database map the table TESTCTL.F0002 to the PROD database table PRODCTL.F0002.

    I hope the above answers your question.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    StevenMStevenM Posts: 3 Bronze 1
    Thanks Eddie. That did the trick!
Sign In or Register to comment.