Comments
Sort by recent activity
Yeah it's the latest version and I think I was premature in my thinking it was running in a transaction, it's running fine.
I think a nice feature would be to have a script generater from the GUI settings to commandline or XML file.
Thank you / comments
Yeah it's the latest version and I think I was premature in my thinking it was running in a transaction, it's running fine.
I think a nice feature would be to have a script generater from the GUI s...
But it's still being run in a transaction!
The GUI runs fine with the same settings.
Help... / comments
But it's still being run in a transaction!
The GUI runs fine with the same settings.
Help...
<?xml version="1.0"?>
<commandline>
<database1>*****</database1>
<server1>*****</server1>
<username1>*****</username1>
<password1>*****</password1>
<database2>*****</database2>
<server2>*****</server2>
<include>Table</include>
<include>Table:*****</include>
<include>Table:*****</include>
<columns>*****</columns>
<include>Table:*****</include>
<exclude>Table:*****</exclude>
<exclude>Table:*****</exclude>
<options>n</options>
<synchronize/>
</commandline> / comments
<?xml version="1.0"?>
<commandline>
<database1>*****</database1>
<server1>*****</server1>
<username1>*****</username1>
<password1>*****</password1>
<database2>*****</database2>
<server2>*****</serv...
I receive the following output from using the verbose option and as you can see there is no compare or mapping.
SQL Data Compare running with SQL Option: None (OK).
SQL Data Compare running with Mapping Option: None (OK).
SQL Data Compare running with Comparison Option: None (OK).
SQL Data Compare running with SQL Option: OutputComments (OK).
This must be the reason for the object reference not set error. I included 'includeidentities' in the <options> clause and it fixed the issue with my problem.
Cheers / comments
I receive the following output from using the verbose option and as you can see there is no compare or mapping.
SQL Data Compare running with SQL Option: None (OK).
SQL Data Compare running with Ma...
No problem, sorted it myself.
Changed this:
<columns>table_name:col1, col2, col3, ...</columns>
To this:
<columns>table_name$:col1, col2, col3, ...</columns>
Forgot that $ signifies the end in a regular expression.
Thanks / comments
No problem, sorted it myself.
Changed this:
<columns>table_name:col1, col2, col3, ...</columns>
To this:
<columns>table_name$:col1, col2, col3, ...</columns>
Forgot that $ signifies the end in a re...