How can we help you today? How can we help you today?

Source and Target

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:

schemacomparefororacles.png

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

schemacomparefororacles.png

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
0

Comments

3 comments

Sort by
  • Simon C
    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
    0
  • kAlvaro
    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.
    kAlvaro
    0
  • David Atkinson
    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
    0

Add comment

Please sign in to leave a comment.