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.

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

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/

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