Running SQL Scripts
Posted on 2001-07-18
We are deploying an application based on MSDE. I would like to store the database creation and generation details in SQL Script files. This is an easy solution with SQL Server because I can simply run the scripts from the command line in the installation with the ISQL tool. (Note, I can't use an interactive solution because from the user's standpoint, the database create's itself on install). The problem is now the solution is based on MSDE, which I am not entirely sure if ISQL (not ISQL/w) is deployed with MSDE. If it is not, is it redistributable. If it is not redistributable, does anybody have some good ADO code samples to read an SQL script that uses the same syntax as ISQL. What I mean by syntax, is support for the "USE <DATABASENAME>" and Go command?