Create project database structure

Do the following:

  1. In the SQL Server project management dialog, select the Databases tab.

  2. Click New. The New Database dialog opens.

  3. Enter the desired description for the database.

  4. In the Server field, enter the name of the server in the same way as before, i.e. the server, server and instance, or server and port as follows:

    • If the instance uses the default port 1433, enter the name of the server only, e.g. SERVER01.

    • If the instance uses a static port other than 1433, enter the name in the format [server name],[port], e.g. SERVER01,1910.

    • If you did not define a port at all or you defined a dynamic port, enter both the server name and the instance name in the format [server name]\[instance], e.g. SERVER01\MSSQLSERVER.

    In this example, the instance uses the default port 1433 so the connection will be made with the server name SERVER01.

  5. Click Test. If the server connects, the Testing database connection dialog opens and asks about updating/creating database tables.

  6. Click Yes. The Update / create database tables dialog opens.

  7. In the table's Create column, click the checkbox to select it.

  8. Click Update / create database tables. The program informs you of a successful creation.

  9. Click OK.

  10. Click Close.

  11. Close the New Database dialog by clicking OK. The project database is now ready to be used.

Next, create the shared database structure.