Create the database model with Microsoft SQL Server Management Studio
-
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
-
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.
-