Posts
Sort by recent activity
Feature enhancement: Where clause editor max size
Request for a feature enhancement, make the max size for the where clause editor much larger (currently just over 4k chars). I generally have to compare larger sets of data where I'm doing an IN st...
Request for very minor UI changes in data comp + sql comp
Respectfully requesting very minor UI changes in data comp. I use both tools religiously daily for various tasks, and use the keyboard exclusively for saved projects that basically just need to be ...
Questions on how to programmatically sync w/ where clause
Brief background on what I am trying to do:
I need to sync a large database. The large majority of tables are small and can be copied in full (can be done with a batch file). There are about 12 tab...
Question regarding how tables are analyzed in cmd mode
I have a question regarding how tables are analyzed for comparison while running from the command line.
I have a long list of tables to <include>. There are about 12 tables I do not want to process...
BUG: Problem with comparison when a linked server exists.
Setup:
Server1 = source database
Server2 = destination database (this database will be updated).
Server2 contains a linked server pointing to server1 for running various queries with.
When running ...
How to include all tables in a script file?
According to the help, I should be able to use this command to copy data from all tables:
<Include objecttype="Table">
If I want to exclude any tables, I put the exclude list after the include:
<ex...
How to use comparison keys in .xml files?
How do you specify a comparison key in a .xml file?
<?xml version="1.0"?>
<commandline>
<server1>db1</server1>
<server2>db2</server2>
<include>Table:ImportStatus</include>
<comparisonkeys>ImportSta...
Several questions regarding synchronization of a large db
Scenario:
Database1 is a live database with about 100 gig of data.
Database2 is a test database which needs updated nightly.
Using SQL compare, I can successfully update the schema of Database2 wit...