BA 371 VB.Net Assignment 3: SQL Interpreter for SQL Server

 In this assignment you'll write the VB.Net code for a SQL script interpreter, that is a program that can read an SQL script and execute its statements. Later in the course you will use this interpreter to run the case study's SQL database schema creation scripts against a (blank) database.

Click here to download a demo version of the program that runs against a Microsoft SQL 2008 database.
Click here to download a demo SQL script file.

To run the program:

1. Start the downloaded program. It will prompt you for both the SQL script and the database name 
2. Provide the path to the SQL script file and the name of your database.
3. If the program reports that it cannot open the script file, make sure you are providing it the proper path to the file.
4. After successfully running the program, open the database in MS SQL 2008 and see the new tables created by the program.

Requirements:

• Program the interpreter as a command-line (console!!) application.
• The interpreter should prompt for both the file containing the SQL script and the name of the MS SQL database.
  
• The interpreter should echo (print to the screen) each SQL statement before running it against the database.
• The interpreter should catch any errors thrown by the database engine and print them to the screen, immediately following the statement causing the error.
• The interpreter does not have to handle SQL comments.
• The interpreter does not have to 'undo' any previously executed statements when it runs into an error condition.
• The interpreter should only open and close a connection with your database once (open at the start of the program and close when finished executing SQL statements).
• The interpreter should never terminate without first closing a previously opened database.
• Code the behavior of the program such that the command window in which the interpreter runs stays on the screen even when triggered from Windows Explorer (note: this does not have to be slick! Just include something so that it takes an action from the user to make the window disappear).