Red Gate forums :: View topic - Source and Target
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle Beta
Schema Compare for Oracle Beta forum

Source and Target

Search in Schema Compare for Oracle Beta forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
kAlvaro



Joined: 18 Jan 2010
Posts: 9
Location: Spain

PostPosted: Mon Jan 18, 2010 12:23 pm    Post subject: Source and Target Reply with quote

I can't understand how the terms "source" and "target" are used in this application. If I set a source database on the left and a target database on the right I'd expect to obtain SQL code to migrate changes from source to target. There're even blue arrows pointing from left to right. However, it appears to be the opposite way.

The bottom panels do not really help:



The icon suggests a column is dropped (correct) but the changes are applied from right to left (weird).



The icon suggest a column is added (correct), the changes happen from right to left (weird) yet the arrow points from left to right (what?).

I'm not a native speaker and that might be the issue but... Am I the only one who finds it all counter-intuitive?
Back to top
View user's profile Send private message
Simon C



Joined: 26 Feb 2008
Posts: 140
Location: Red Gate Software

PostPosted: Mon Jan 18, 2010 1:55 pm    Post subject: Reply with quote

To clarify, the sync script you get from the sync wizard is a script to run on the target database that will make it the same as the source database.

Could you give an example of the sync script it generates going the wrong way, with the differences it should be syncing?

SimonC
Back to top
View user's profile Send private message Send e-mail
kAlvaro



Joined: 18 Jan 2010
Posts: 9
Location: Spain

PostPosted: Mon Jan 18, 2010 4:45 pm    Post subject: Re: Reply with quote

Simon C wrote:
Could you give an example of the sync script it generates going the wrong way, with the differences it should be syncing?


The sync process itself is fine, sorry if I made you think it's not.

My concern was about the way it's expressed with words and icons. I had the mental image that you pick the source database, apply some changes to it and obtain the target database:

SOURCE => TARGET

(Or, in another words, FROM => TO.)

However, as you have just described, the program does the opposite: it applies changes to TARGET so it becomes SOURCE. And it represents it with the same left-to-right arrows:

SOURCE => TARGET

Perhaps I'm confused by the concept of CHANGESET used by version control tools. This is the first (functional) database compare program I ever use.
_________________
Álvaro G. Vicario - Burgos, Spain
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Tue Jan 19, 2010 10:19 am    Post subject: Reply with quote

You're right that version control tools show your latest version on the right hand side and the working base on the left, which may be interpreted as the opposite, and consequently confusing.

What you can do if you prefer for the left hand schema to be the target is change the direction of the arrows. You can do this by double clicking on the large arrow either on the project configuration dialog or the comparison results screen.

Thanks for taking the time to give us your feedback.

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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