These are terms used in the transfer process discussion.
This refers to the DBMS that the DirectConnect server is always connected to; it is implied in the transfer statement.
This database is another DBMS that is defined in the connection string within the transfer statement. The secondary database can be a database that is targeted by another access service.
The source is defined as the database the data is coming from.
This database is where the data is being sent, also called the target. Either the primary or secondary database can be the source or destination, depending on whether you use the transfer from or the transfer to command.
Figure 8-1 shows the access service configured to access a particular primary database. The secondary database is an ASE database located on the LAN. The client application can transfer data from the primary database to ASE, or from ASE to the primary database.
Figure 8-1: Access service data transfer between databases
During a transfer:
Data flows from a table in the source database, through the DirectConnect server, to the target database. Although the client application initiates the transfer, the data does not flow through it.
The DirectConnect server becomes a client to the secondary database.