Activity overview
Latest activity by si_he
Command line where clause
I need to schedule regular data compare jobs, but I need to use a WHERE clause. Is there any way to specify a WHERE clause using the command line tool? or is the API the only way of doing this?
T...
Restoring
Stupid question but I'll ask anyway... :roll:
Is it possible to restore a backup done in SQL Backup v5 using the SQL native restore command on a server that does not have SQL Backup installed?
Many...
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...
<?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...
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...
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 transaction in XML argfile
Please can someone explain how I can set the commandline object to not use transactions within options?
I have tried using the following in the XML file:
<options>None</option> and <options> option...
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...
Excluding columns using XML file
I'm trying to create an XML file with all the relevant tables included. However, one of the table has an image data type that I need to exclude.
The following snippet is from the XML file I'm usin...