Enable automatic copying of .mdb files from the server to offline clients

Note:
Each night, the SQL job OfflineExtract updates the .mdb files automatically. If you are setting up offline Polaris at a time other than at the beginning of the day, you must manually run the SQL Server job to update the .mdb files before copying them to the offline client(s). See Manually update the offline .mdb files.

No matter whether your library is setting up offline processing to upload the offline transaction files manually or automatically, you first need to copy the PolPatron.mdb and PolSystem.mdb files from the server to the designated offline workstations, either by manually copying the files or copying them automatically.

To enable the Copy Offline Files job that automatically copies the . mdb files from the server to the designated offline workstations, you must create a SQL Server credential, then create a proxy account to associate this credential with the process, so that it can access and update the designated offline workstations. The credential name and proxy name can be anything you choose.

Note:
If you are using automated offline processing, you must also create a credential and proxy to allow the automatic upload process. See Enable and schedule the Automated Offline SQL job.

To enable the Copy Offline Files job to automatically copy .mdb files from the server to the designated offline workstations:

1. Create the SQL Server credential. The credential account must be a domain account that has rights to the domain workstations to which the job will copy the .mdb files.
2. Then create the proxy under PowerShell.

Once the credential and proxy are set up, the SQL Agent can copy the .mdb files from the server to the designated workstations.