single table compare from command line

dbaman6

I am having trouble comparing 1 single table from the command line

SQLCompare.exe /verbose  /server1:HENRY /server2:HENRY 
/username1:XX /username2:XX /database1:D11  /database2:RETAILDEV 
/include:table:ALTVENDOR /scriptfile:c:\test\sqlout_migration_script.sql

and it keeps trying to do all tables in the database.

Also, what is the format for the xml file for putting all these parameters in to simply the command line?

JonathanWatts

Hi there,

Which version of the command line are you using, as I have been trying your command string this morning and only table I get displayed is the matched table displaying. I do however get all the other objects that aren't tables displaying. If you want to get rid of all the other object types too you will have to use:

/include:all:ALTVENDOR

The xml argfile should be something likeL

<?xml version="1.0" encoding="utf-8" ?>
<commandline>
    <scriptfile>c:\test\sqlout_migration_script.sql</scriptfile>
    <username1>XX</username1>
    <username2>XX</username2>
    <database2>RETAILDEV</database2>
    <database1>D11</database1>
    <server2>HENRY</server2>
    <server1>HENRY</server1>
    <verbose/>
    <include objecttype="table" matches="ALTVENDOR"/>
</commandline>

Hope this helps,

Jonathan