Red Gate forums :: View topic - Command line output explanation
Return to www.red-gate.com RSS Feed Available

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

Command line output explanation

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
paule123



Joined: 12 Feb 2008
Posts: 28

PostPosted: Sat Jun 30, 2012 8:25 pm    Post subject: Command line output explanation Reply with quote

I'm using SQL Data Compare 8.1.0.4 to do a command line sync using a project set up in the GUI. I call the project like so:

"c:\program files\red gate\sql data compare 8\sqldatacompare.exe" /project:"C:\Users\Administrator\Documents\SQL Data Compare\SharedProjects\my-database-sync-project.sdc"

I couldn't find documentation on what exactly the "<<" "<>" ">>" indicators mean under the "DB1" and "DB2" headings in the output.

When DB1 is >> and DB2 is blank, I assume new records were pushed from DB1 to DB2. Fine.

However when I see DB1 <> and DB2 <> on the same line for the same table, I'm confused about what's going on.

Of most concern is seeing DB1 blank, and DB2 << which seems to indicate DB2 pushed changes back to DB1. I definitely don't want this to happen given that the project was set up in the GUI to go in one direction, from DB1 to DB2. I hope the command line version is not actually syncing some data the opposite way from DB2 to DB1?
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 84

PostPosted: Mon Jul 02, 2012 7:54 pm    Post subject: Reply with quote

Hi paule123,

Here is what the output of the command line means:

When comparing DB1 with DB2:

== == Identical objects

<> <> Different objects

<< Objects that exist in DB2 that don't exist in DB1

>> Objects that exist in DB1 that don't exist in DB2


Best Regards,
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
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