Posts
Sort by recent activity
XML Comparison Columns
When using an XML File, Is There A Way To Tell SQLDataCompare
Which Columns to use in the comparison?
I have two tables to compare and without getting into a lot of detail, I need to compare the no...
SQL Data Compare - Exclude Rowguid From Comparison
Getting Closer.
I have setup an XML Argument file to compare two tables on two different servers and put the output of the comparison into a log file.
The tables are identical except for 2 things.
...
SQLDataCompare - EXCLUDE Column In XML File
So in my last episode, I was setting up a DATACOMPARISON using an XML file.
Table 1 is to be compared to Table 2. Table 1 has jobs run against it which delete data from the table. The comparison ...
Redgate SQL Compare XML Syntax INCLUDE Syntax
I am trying to compare a table that exists in separate databases on two different servers.
Table 1 is the master, there is a job that will truncate all data once a week and then repopulate it.
Tabl...
XML Command Line Switches...
I currently have a batchfile calling SQLDATACOMPARE to compare 1 table on two different servers, the target table is only supposed to have rows added or modified NOT deleted so I use the command li...
Compare Not Working In VB.NET
Ok, I am stubborn. I have the project working from the command line using SQLDATACOMPARE /PROJECT:"C:\ProjectName.SDC" but I cannot seem to get this to work in my VB.NET project.
I don't get any ...
How To Get The Databases To Synchronize.
Following the example in your tool kit, I believe I have figured out how to load a project within VB.NET and COMPARE the databases...now how to I get the databases to synchronize? '
' Copi...
Automating A Comparison Project
Ok, I have a project setup like I want and all seems to work quite well.
I would now like to automate this project using task scheduler or some other utility.
Can anyone tell me how to do this?