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.