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 – server and instance name (in this example, UHURA\SQLEXPRESS)

    • Initial catalog – 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 Connecion string, click the button. The Connection Properties dialog opens.

  7. For Select or enter a database name, select EDBUserCommon.

  8. Click OK.

  9. On the Create column, select a table.

  10. Click Update / create database tables. The Update / create database tables dialog opens.

  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.