Re: How To Execute A Sql Script File From ADO.NET Using VB.NET

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/17/04

Next message: William Ryan eMVP: "Re: VB ADO.NET Concurrency, Access, date fields and parameters"
Previous message: Andy Gaskell: "Re: newbie question (SQL)"
In reply to: SqlJunkies User: "How To Execute A Sql Script File From ADO.NET Using VB.NET"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 17 May 2004 12:57:25 -0400

http://www.knowdotnet.com/articles/ddl.html

Good luck,

Bill

www.devbuzz.com
www.knowdotnet.com

"SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote in message
news:e5C$hZCPEHA.2976@TK2MSFTNGP10.phx.gbl...
> I have a sql script file containing a number of batch commands to create a
new database with 50 tables. Is there anyway i can use ado.net to open this
file and execute the sql command in side in a batch format. Basically I
would like to execute the myscriptfile.sql from vb.net using ado.net
>
> ---
> Posted using Wimdows.net NntpNews Component -
>
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Next message: William Ryan eMVP: "Re: VB ADO.NET Concurrency, Access, date fields and parameters"
Previous message: Andy Gaskell: "Re: newbie question (SQL)"
In reply to: SqlJunkies User: "How To Execute A Sql Script File From ADO.NET Using VB.NET"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

executing a sequence of mysql statements
... I need to execute a sequence of mysql statements, ... then copy some records from tables of an old database to ... I think I shall write a SQL script file, ...
(comp.lang.php)
MaxDB: how to make it read and execute external SQL Script files ???
... Anyone had any luck in getting MaxDB7.5 database to read and execute a ... sql script file (for batch creation/deletion of tables etc.)? ... Thnx in advance! ...
(comp.lang.java.databases)
MaxDB: how to make it read and execute external SQL Script files ???
... Anyone had any luck in getting MaxDB7.5 database to read and execute a ... sql script file (for batch creation/deletion of tables etc.)? ... Thnx in advance! ...
(comp.os.linux.misc)
Using OSQL utility
... I run a SQL script file with OSQL.I execute this statement in Delphi 5 with WINEXEC like this: ...
(microsoft.public.sqlserver.programming)