OSQL vs SqlConnection

• kromo

  SSC-Addicted

  Points: 459

  More actions

  January 15, 2004 at 11:09 am

  #161088

  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!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738171

  More actions

  January 15, 2004 at 4:56 pm

  #490332

  I'm not sure one if better than the other. I like osql or isql since scripting it pretty simple to use and I can always launch outside of another tool if I need to.