| Author |
Message |
kAlvaro
Joined: 18 Jan 2010 Posts: 9 Location: Spain
|
Posted: Mon Jan 18, 2010 12:23 pm Post subject: 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:
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 |
|
 |
Simon C
Joined: 26 Feb 2008 Posts: 140 Location: Red Gate Software
|
Posted: Mon Jan 18, 2010 1:55 pm Post subject: |
|
|
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 |
|
 |
kAlvaro
Joined: 18 Jan 2010 Posts: 9 Location: Spain
|
Posted: Mon Jan 18, 2010 4:45 pm Post subject: Re: |
|
|
| 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 |
|
 |
David Atkinson
Joined: 05 Dec 2005 Posts: 1079
|
Posted: Tue Jan 19, 2010 10:19 am Post subject: |
|
|
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 |
|
 |
|
|
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