Accessing Data on a Remote Engine Using PCC
You can use PSQL Control Center to access data on a remote machine on which a PSQL v12 engine is installed.
*Tip: You will need to log in as an administrative user on the remote engine to perform most functions. This means that you must have full administrator-level rights on the remote server or be a member of the Pervasive_Admin group defined on the remote machine.
►
To access data on a remote PSQL engine
1
In the PSQL Control Center, double-click the remote PSQL Engines node, then double-click Databases.
Figure 7 Expanding the Databases List for an Engine
2
In the Databases list double-click DEMODATA, then double-click Tables.
3
Double-click the Dept table from the Tables list.
 
Figure 8 Selecting the Dept Table in DEMODATA
 
By default, a SELECT * FROM query is run and the table results are displayed in an active grid as shown in Figure 9.
The data displayed in the active grid that loads is updateable. That is, changes you make to the data in that grid are stored to the database.
Figure 9 Displaying the Dept Table in DEMODATA
4
Refine the query to restrict the results to only departments that start with the letter M by altering the query at the top half of the screen with the following statement:
SELECT * FROM Dept WHERE Name LIKE 'M%'
5
Click the Execute in Grid toolbar button or press F9 to display the results of the revised query shown in Figure 10.
Figure 10 Refining Your Query - Dept Table in DEMODATA
You have now obtained data from the remote database engine.
For information on advanced operating and maintenance tasks, including database operations, see the Advanced Operations Guide.