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)
Comments
1 comment
-
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
Add comment
Please sign in to leave a comment.