single table compare from command line

dbaman6dbaman6 Posts: 7
edited April 12, 2007 7:21AM in SQL Compare Previous Versions
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?


  • 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:

    The xml argfile should be something likeL
    <?xml version="1.0" encoding="utf-8" ?>
        <include objecttype="table" matches="ALTVENDOR"/>

    Hope this helps,

    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.