Multiple Database Transfer Utility

Using this utility, users with multiple databases have the ability to transfer the monthly G/L account activity from one database to another. In order for this to work successfully both databases MUST be in the same calendar month & MUST have the same chart of accounts. The procedure must be run from the database that the transactions are being transferred TO.

Step 1: Running the Utility

From the main General Ledger screen select Utilities, then select the Multiple Database Transfer Utility. Upon making this selection, you will be met with the following message which gives a detailed description of the utility, as shown below:

Press OK to continue.

The following screen appears for verification purposes. The database that is displayed is the one in which the batch of journal entries is being created. This batch will contain account activity for the main database you will be asked to specify on the following screen.

Press the spacebar to continue.

The following screen will appear:

Main DB Location – The location of the dphs.db file for the Main Database (database you are transferring FROM) will default into this field. If nothing appears, contact DPHS Support for assistance.

Connect Mode – Specify whether or not this is a Multi-User or Single-User system. If there is no server running for the Main database, Enter "Single-User" otherwise enter "Multi-User" and enter the connection options in the next field.

Connect Options – For "Single-User" connect mode, leave this field blank. For "Multi-User" connect mode, use the default settings that appear. If nothing appears, contact DPHS Support for assistance.

Press F2 to continue & the procedure will connect to the main database. Once connected it will return a message asking if you want to continue. Select ‘Yes’ to continue or ‘No’ to exit the procedure.

If you select Yes, the system will then build the batches in the database in which you are running the procedure, and will produce a message similar to the one shown below when complete.

Press OK and you will be returned to the main Utilities screen.

Step 2: Post the Batch

Once the procedure is complete, the last step is to Post the batch from within General Ledger > Journal Entries. You may view the batch prior to posting to verify information. Once posted, you will have access to the transactions in this database!

That’s it! The transfer is complete. If you have further questions, please visit our website www.dphs.com OR contact Data Plus Support.