I have a large .sql script that contains various commands to create a schema for a database. Currently I am using the .NET Process object that launches the osql utility and passes the script as a parameter. It all works fine, but I was wondering if I should be using SqlConnection instead. Is one method better than another from a programming perspective? Does anyone have any thoughts on this?
Thanks in advance!