Terms in the transfer process

These are terms used in the transfer process discussion.

Primary database

This refers to the DBMS that the DirectConnect server is always connected to; it is implied in the transfer statement.

Secondary database

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.

Source database

The source is defined as the database the data is coming from.

Destination database

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

Access service data transfers between databases.

During a transfer: