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

single table compare from command line

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?
dbaman6
0

Comments

1 comment

Sort by
  • 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
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.