This tutorial takes you through the process of using Microsoft SQL Server 2008 Management Studio to create a SQL Server database and to create the schemas and tables required to complete the OpenESQL Assistant tutorials.
- Start the Microsoft SQL Server 2008 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, located in your
%ProgramFiles(x86)%\Micro Focus\Studio Enterprise Edition x.x\Examples\Visual Studio Integration\sql\OpenESQL\SampleData directory.
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 2008 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
%ProgramFiles(x86)%\Micro Focus\Studio Enterprise Edition x.x\Examples\Visual Studio Integration\sql\OpenESQL\SampleData directory.
- Enter:
sqlcmd -S . -E -i CreateAndLoadOESQLDemo.sql
This completes the tutorial. Next, please complete
Tutorial: Create and Configure a Visual Studio Project.
