Data Compare Build Task to generate delta insert script for selected tables

997 Views Asked by At

I want to automate the process of delta insert script creation for master table by comparing development Database to production database.

Have used this tool "Microsoft Visual Studio Team System 2008 Database Edition Power Tools".

This is the syntax that can be used to compare two databases and generate the delta insert script.

MSBuild /t:SqlDataCompareTask /p:SourceConnectionString=”ValidConnectionString1” /p:SourceDatabaseName=”DatabaseName1” /P:TargetConnectionString=”ValidConnectionString2” /p:TargetDatabaseName=”DatabaseName2” /p:OutputPath=”FullPathForDataCompareReults” /p:OutputFilename=”FilenameForDataCompareResults”

Now what i am looking for is a way to pass table names, and only these tables should be considered for generation of delta insert script.

If any of you had tried simillar thing let me know what is the alternate approach that you took.

1

There are 1 best solutions below

2
On

As an alternative: redgate's SQL Compare and SQL Data Compare.