Source and Target

Early Access Program for Schema Compare for Oracle

Moderators: David Atkinson, eddie davis, richardjm, alice.easey, Tom Harris

Source and Target

Postby kAlvaro » Mon Jan 18, 2010 12:23 pm

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:

Image

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

Image

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?
kAlvaro
 
Posts: 9
Joined: Mon Jan 18, 2010 11:33 am
Location: Spain

Postby Simon C » Mon Jan 18, 2010 1:55 pm

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
Simon C
 
Posts: 140
Joined: Tue Feb 26, 2008 4:56 pm
Location: Red Gate Software

Re:

Postby kAlvaro » Mon Jan 18, 2010 4:45 pm

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
kAlvaro
 
Posts: 9
Joined: Mon Jan 18, 2010 11:33 am
Location: Spain

Postby David Atkinson » Tue Jan 19, 2010 10:19 am

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to Schema Compare for Oracle Beta

Who is online

Users browsing this forum: No registered users and 0 guests