This tutorial takes you through the process of using Microsoft SQL Server Management Studio to create a SQL Server database
and to create the schemas and tables required to complete the OpenESQL Assistant tutorials.
- Go to
CreateAndLoadOESQLDemo.txt.
This SQL script creates the SQL Server database.
- Using your browser's
Save As feature, save this as a flat text file on a local drive. Name the file
CreateAndLoadOESQLDemo.sql.
Note: If your browser adds any extraneous text, edit the script file to remove the extraneous text.
- Start the Microsoft SQL Server Management Studio.
- Connect to the server where you want to create your database.
Note: The user ID and password you provide must log you on to SQL Server with
dbadmin or
sysadmin permissions that enable you to create a SQL Server database.
- Open and execute
CreateAndLoadOESQLDemo.sql.
This SQL script creates a SQL Server database named OESQLDemo, and creates the schemas and tables required to complete the
OpenESQL Assistant tutorials.
- Close SQL Server Management Studio.
Note: As an alternative, you can create the SQL Server database from the command line as follows:
- At a command prompt, change to the directory where you saved the
CreateAndLoadOESQLDemo.sql file.
- Enter:
sqlcmd -S . -E -i CreateAndLoadOESQLDemo.sql