Red Gate forums :: View topic - Possible to ignore object owner when comparing?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Possible to ignore object owner when comparing?

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
StevenM



Joined: 27 Nov 2012
Posts: 2

PostPosted: Tue Nov 27, 2012 5:01 pm    Post subject: Possible to ignore object owner when comparing? Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 938
Location: Red Gate Software

PostPosted: Thu Nov 29, 2012 7:14 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
StevenM



Joined: 27 Nov 2012
Posts: 2

PostPosted: Thu Dec 06, 2012 9:43 pm    Post subject: Reply with quote

Thanks Eddie. That did the trick!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group