Possible to ignore object owner when comparing?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings

Possible to ignore object owner when comparing?

Postby StevenM » Tue Nov 27, 2012 5:01 pm

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
StevenM
 
Posts: 2
Joined: Tue Nov 27, 2012 4:56 pm

Postby eddie davis » Thu Nov 29, 2012 7:14 pm

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby StevenM » Thu Dec 06, 2012 9:43 pm

Thanks Eddie. That did the trick!
StevenM
 
Posts: 2
Joined: Tue Nov 27, 2012 4:56 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests