Upgrade from Access Database

This article applies to users of Patient Manager Advanced .

If you have high volume of data or want to move from single user to multiple users in a networked environment, we recomment upgrading from MS Access databases to more faster and reliable MSDE, MSSQL or MySQL databases.

If you're not sure what database to upgrade to, read Choose the right Database.

Steps to Upgrade from Access databases to MySQL:

1. Install and Create the new MySQL Database

1.1. Enable Multiple Users - go to Administration -> Settings and check the Enable Multiple Users checkbox.
1.2. Restart the application and start Database Manager. Read here how to do it.
1.3. In Database Manager click New to install and create a new database connection to the application.
1.4. Click Next and then Start. The DatabaseInstaller program will be downloaded and started.
1.4.1. In the DatabaseInstaller program click Next in the wizard pages and wait for the program to install
1.5. A detailed guide of this process you can find at http://www.vertikalsystems.com/documents/PatientManager-MySQL-Network-Installation-Automatic.pdf

2. Synchronize from Access to the New MySQL Database

2.1. Restart the application, and login into the Access database by choosing it in the Login window.
2.2. Go to Tools -> Database Sync in the main menu.
2.3. In the opened viewer, press the New Database Sync button and create the sync.
2.4. Once created, double-click on it to edit it.
2.5. Click on the Change link, situated under the Remote Database label.
2.6. With the Database Connection Wizard select the newly MySQL created database. Typicaly in the Connection Setting wizard page, the values will be:
- Server Name : the name of the host computer
- User Name : root
- Password : admin
- Database : VS
2.7. Click the Synchronize button to run the Synchronization.

Related Articles

Database Usage Scenarios

How to install in the Network

Connect over the Internet

Top of Page

Using Patient Manager

Getting Started

Medical

Office

Billing

Reports

Tools

Administration

How To

Upgrade from Access Database