Create the database model with Microsoft SQL Server Management Studio

1. If you are still connected to the database (see chapter Creation of the database, login, and user), re-connect as the ImageMaster database user:

   Right-click on the root node of the tree in the Object Explorer panel and select Disconnect:

   

   Figure 544: Microsoft SQL Server Management Studio – disconnect database

   Use File > Connect Object Explorer to re-connect to the database:

   

   Figure 545: Microsoft SQL Server Management Studio – new connection

2. Execute the “ima9_core_sqlserver.sql” script:

   Use File > Open > File to open the db-model\sqlSQLServer\ima9_core_sqlserver.sql file:

   

   Figure 546: Microsoft SQL Server Management Studio – open ima9_core_sqlserver.SQL script

   In the toolbar, in the list next to the Execute button, select the database created in chapter Creation of the database, login, and user:

   

   Figure 547: Microsoft SQL Server Management Studio – select the created database

   • Uncomment the top two lines that start with “-- :SetVar” (remove the leading --).

   • Change the values of the TABSPACE and IDXSPACE variables if desired. By default, all tables and indexes are created in the default filegroup).

   • Select Query -> SQLCMD Mode in the menu:

     

     Figure 548: Microsoft SQL Server Management Studio – select query mode

   • Click the Execute button in the toolbar: the query will be executed.