Setting up a Database
- Updated2024-10-31
- 3 minute(s) read
Setting up a Database
Before you can use PAtools to create tests, you must set up a database to store your tests.
Adding a New SQL Database on a Windows
Machine
To add a new SQL database on a Windows machine, refer to Create a database.
When you add a new SQL database, the database is empty. In this case, you must configure the empty database.
Restoring a Database Backup
To set up an existing database on a SQL Server, use PAexpress to restore a database backup.
You can restore a database backup that you were given. Alternatively, PAtools includes a default database backup that you can use to start a new project. The default database backup is in the PAtools application folder.
-
Copy the database backup file to the machine where you installed the SQL
Server.
If you are restoring the default database backup that is installed with PAtools, copy PAtools_DB.bak from C:\Program Files (x86)\National Instruments\PAtools <version>\DB\PAexpress\Dbs
- Open PAexpress.
-
Click the folder icon next to the Server field.
A Connecting to SQL Server window appears.Note If you cannot connect to the database, verify with your IT department that you have access rights to connect and restore the database.
- In the Connecting to SQL Server window, enter or select your Database server.
-
Click OK.
Note If you cannot connect to the SQL Server using PAexpress, verify with your IT department that you have the required access rights to restore a database backup.The SQL Server appears in the left pane of PAexpress.
- Click Restore database.
-
In the Select backup file field, click
... next to the Filename field
and select the database backup file that you copied to the machine with the SQL
Server.
The Restore options section automatically populates with information about the database.
- Optional: In the Database name field, rename the restored database.
-
Click Restore.
A popup confirms successful restoration of the database.
-
Use PAconfigurator to ensure the appropriate PAtools users have administrator
rights for the database.
Refer to Manage Users for more information.
Importing a Database Module
Use PAconfigurator to import database modules.
- Open PAconfigurator.
- Click Development.
-
Right-click the location where you want to import a database module and select
Import.
For example, import a database module to Application Components.
- Select the database module that you want to import.
In This Section
Related Information
- Create a database
- Setting Up the SQL Server
PAtools supports the Microsoft SQL Server as a database management system. All data configured in PAconfigurator and other PAtools applications is saved in a SQL database that the Microsoft SQL Server manages.
- Manage Users
- SQL Server Management Studio