Running a SQL Data Compare script from a .NET app...

spireite

Can I ask how you do it? I have an application in VB which uses SQL-DMO to run the SDC geberated scipt.. Is there a way in .NET to run this script WITHOUT needing DMO, or do I need to still use DMO? How does SDC execute the script? (if you don't mind me asking)

James Moore

You can always use ADO.NET to run the script.. have a look at the following:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx

You might also want to look at the SqlConnection object.. but it should be fairly easy to put some code together which uses ADO.NET.

Hope this helps,

- James
--
James Moore
Red Gate Software Ltd