What are the challenges you face when working across database platforms? Take the survey
Options

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?

Comments

  • Options
    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
    Jonathan Watts

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