Options

SQL Data compare running from CMD line

Steve KnapperSteve Knapper Posts: 2
edited June 7, 2006 1:23PM in SQL Data Compare Previous Versions
Hi, I am trying this software for the first time.
I need to automatically sync a table on different SQL servers.
I have created a batch file to automate this task at regular intervals.
But its complaining about the columns to map.

I have added the '/columns:an_quote_quad.QuoteID' section to my command line, where an_quote_quad is the table name and QuoteID is the column name (this is the primary key to the table).

Please can anyone point me in the right direction on this.

regards
Steve
· Share on Twitter

Comments

  • Options
    david connelldavid connell Posts: 172 Silver 1
    Hi Steve,
    The documentation says
    columns:<table or view regex>:<column names>
    Alias: /cols


    Specifies which columns within a table / view are to be migrated.

    Use this argument to specify in which columns data to be migrated resides. Table / view names are matched using a regular expression to prevent you from needing to specify fully qualified names, however under most circumstances it will not make sense to supply a regular expression that would match more than one table or view. Columns should be specified as a comma-delimited list of their names.

    So I would presume that you should have
    /columns:an_quote_quad:QuoteID

    Note the second :

    Hope that helps.
    David Connell
    · Share on Twitter
This discussion has been closed.