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. For Server, enter the server and instance name (in this example, UHURA\SQLEXPRESS).

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. On the Create column, select the table.

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.