Automating a 2008 Data Compare
Is there a way for me to write out a delta script between, say two tables? Example let say i want to write out a delta for Table A between Test and Model. Users have access to Update Table A in test, but not model. To move the data to Model i need the delta's between Test and model. Is there a way for me to automate an output of the script update using SSIS or Visual Studio's? In my SSIS package i am deleting from the model table and moving the test table to production. Before that is done I would like to kick out a delta file and a rollback file. Any suggestions would be great.
November 11th, 2010 9:13pm

Hi Alan, By default, there is no direct way to automatically generate a script file for data rollback and so on. As a workaround, I would suggest you invoking SQL Server SQL Server Management Objects (SMO) object in a script task to generate the script. For more information, please see: SQL Server Management Objects (SMO): http://msdn.microsoft.com/en-us/library/ms162169.aspx Script Task: http://msdn.microsoft.com/en-us/library/ms141752.aspx Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 1:54am

Take a look at third party tool from www.red-gate.com named SQLCompare and SQLDataCompareBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
November 15th, 2010 3:13am

Alan, There are third party APIs available that could make this a lot easier. Red Gate is one such supplier, see their SQL Compare and SQL Data Compare products, both of which have a full API option.http://www.sqlis.com | http://www.konesans.com
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 4:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics