Create shared database structure

Shared databases contain shared design content, such as cable types, product information, and plate definitions. When you are working on a project, you select design content for the project from these shared databases, which then ends up as the project design content.

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 or select the following information for the database:

    • Description – Shared databases

    • Database type – Shared databases

    • Server – The server name, the server name and the port, or the server name and the instance name 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.

    • Initial catalog – The name of the shared database. In this example, the name is EDBUserCommon.

    • Root directory for projects – The folder whose sub-folders use this database

  4. Click Test. The Testing database connection dialog opens.

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

  6. Next to Connection string, click the button. The Connection Properties dialog opens.

  7. For Select or enter a database name, select the name of the shared database. In this example, the name is EDBUserCommon.

  8. Click OK.

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

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

  11. Click OK.

  12. Create as many own product databases as you want by repeating the previous steps.

    If the databases are not visible on the list, do the following:

    1. Click Close.

    2. Select the database.

    3. Click DB Update. The Update / create database tables dialog opens and shows you the databases.

    4. Select the databases and click Update / create database tables.

  13. Click Close.

  14. Click OK.

Next, add other users to SQL Server.