Database Manager Tool

This section explains how to use Database Manager.

Before using Database Manager, create an empty SQL Server database.

Using the Database Manager you can:

• Add or remove the AIM Workhub servers and databases.

• Initialize an AIM Workhub database.

  • Create the physical structure of the schema: tables, views and stored procedures.

  • Load the required system information.

• Upgrade a database to the latest version.

• Set the File Store location for a database.

• Update the file references in the database directing you to the new File Store location.

The Database Manager Console is a command-line version of the Database Manager. You can initialize and upgrade the database, and register the File Store from scripts. It can also encode passwords for use in connection strings.

Managing Databases

This section explains how to add and remove databases from Database Manager.

To add a database to a server instance:

1. Open Database Manager.

2. Right-click Server Instances, and then select Add Server.

   The Add Server window opens.

3. Do one of the following:

   • If you know the server name, Type that name in the Server Instance box, and then select OK.

   • If not, select Refresh, and then select the drop-down arrow in the Server Instance box.

   • From the list that appears, select a Server Instance, and then select OK.

4. Right-click the newly added server, select Add Database.

   The Connect to Database window opens.

5. If you want to connect to the database using your Windows credentials:

   1. Select the Windows Security check box.

   2. Type the Database and Schema you want to use in the SQL server, and then select Connect.

6. If you do not want to use your Windows credentials to connect to the database:

   3. Clear the Windows Security check box.

   4. Type the User Account (username) and Account Password (password) of the SQL database, and then select Connect.

Depending on the state of the database, one of the following messages appears:

• The Workhub database has not been initialized. Click to initialize now. See the Initializing the AVEVA Asset Information Management Workhub Database section in this topic.

• The Workhub database is up to date. Click OK. If there are no File Server details, select Register, see the Registering File Store section in topic.

• The Workhub database is not the latest version. Click Yes to upgrade now. See Upgrading AVEVA Asset Information Management.

To add a schema to a Database:

7. Open Database Manager.

8. Right-click the database, select Add Schema.

   The Connect to Database windows opens.

9. If you want to connect to the database using your Windows credentials:

10. Select the Windows Security check box.

11. Type the Database and Schema you want to use in the SQL server, and then select Connect.

12. If you do not want to use your Windows credentials to connect to the database:

13. Clear the Windows Security check box.

14. Type the User Account (username) and Account Password (password) of the SQL database, and then select Connect.

Depending on the state of the database, one of the following messages appears:

• The Workhub database has not been initialized. Click to initialize now. See the Initializing the AVEVA Asset Information Management Workhub Database section in this topic.

• The Workhub database is up to date. Click OK. If there are no File Server details, select Register, see the Registering File Store section in topic.

• The Workhub database is not the latest version. Click Yes to upgrade now. See Upgrading AVEVA Asset Information Management.

To remove a database from Database Manager:

15. Open Database Manager.

16. Right-click the database you want to remove.

17. Select Remove Database.

    Note: This removes the database and schema from Database Manager. The database and schema still exist in the database server machine, and are not deleted.

To remove a schema from Database Manager:

18. Open Database Manager.

19. Right-click the schema you want to remove.

20. Select Remove Schema.

    Note: This removes all schema from Database Manager. The schema still exists in the database server machine, and are not deleted.

Initializing the AVEVA Asset Information Management Workhub Database

Before loading any data into the AIM Workhub database you need to create the correct structure and system information by initializing.

To initialize an AIM Workhub database:

21. Open Database Manager.

22. Expand the Server Instances node, and then under the server and the database, double-click the schema you want to initialize.

    Note: If the server or database is not already added, see Managing Databases for the procedure.

23. If you want to connect to the database using your Windows credentials:

    5. Select the Windows Security check box.

    6. Type the Database and Schema you want to use in the SQL server, and then select Connect.

24. If you do not want to use your Windows credentials to connect to the database:

    7. Clear the Windows Security check box.

    8. Type the User Account (username) and Account Password (password) of the SQL database, and then select Connect.

25. In the Database not initialized window, select Yes. Progress is shown in the Upgrade Status box.

26. When the initialization is complete, select Close.

Registering File Store

To register a File Store with the AIM Workhub database:

27. Open Database Manager.

28. Expand the Server Instances node, and then under the server and the database, double-click the schema you want to update.

    Note: If the server or database is not already added, see Managing Databases for the procedure.

29. If you want to connect to the database using your Windows credentials:

    9. Select the Windows Security check box.

    10. Type the Database and Schema you want to use in the SQL server, and then select Connect.

30. If you do not want to use your Windows credentials to connect to the database:

    11. Clear the Windows Security check box.

    12. Type the User Account (username) and Account Password (password) of the SQL database, and then select Connect.

31. Select Connect.

32. Select OK.

33. Select Register.

34. Change the Binding information if necessary.

35. When the File Server list is populated, select the server where the File Store is located.

    Note: When the Database Manager registers a Workhub Database with the File Store service, it attempts to discover running instances of the File Store service on your network. This is done using WS-Discovery (http://specs.xmlsoap.org/ws/2005/04/discovery/ws-discovery.pdf). If you do not want the File Store service to advertise its endpoint or the Database Manager to send broadcasts to discover instances of this service, block UDP port 3702 in your firewall on the File Store service and Database Manager client machines respectively. Firewalling this port may affect other applications or services that use WS-Discovery.

36. Select Register.

37. Select Close.

To register multiple File Stores to the AIM Workhub database:

38. On the Connect to Database window, select Settings.

    Note: This action disables the Registered Files Stores drop-down menu.

39. On the Configure File Service window, select the Register New File Service option.

    

40. Select Register.

    A new File Store is added to the File Servers drop-down menu. The vault number (in this case 0 and 1) of the File Store is suffixed to the File Server name as visible on the following screen:

    

    Notes:

    • Up to version 5.0.1 of AIM, the last registered vault for a File Server is considered as the current File Store. So the file store registration does not include any vault number.

    • Registered File Stores can be used in Import Controller to define different File Stores for each package.