Page Comparison

If you've been implementing OpenMRS Standalone and want to transition to the Enterprise version you can follow the steps below.

...

1. Make sure you have Tomcat and MySQL installed on the computer designated to be the server
2. Export the standalone database.
   - To connect to the standalone database open MySQL Workbench and from the Database dropdown menu select ---> Connect to Database (control+U is the keyboard shortcut)
   - Find the MySQL connection details in your openmrs-standalone folder in your runtimeproperties file (Username: openmrs, Port: 3316, password is autogenerated by standalone and is in your runtime propertes file)
   - Click Data Export and select openmrs. All the 105 tables will show up with check marks next to them noting that they are ready to be exported. Keep the "Export to Dump Project Folder" option selected and click Start Export (note the file path location to which this dump will be saved)
3. Import the standalone database into your local MySQL installation
   - Open MySQL workbench and from the Database dropdown menu select ---> Connect to Database (control+U is the keyboard shortcut)
   -  Connect to your local MySQL instance. The default hostname and port should be there (127.0.0.1 and 3306 respectively) and change the root username if needed
   - Now click on "Data Import/Restore" in the left bar menu
   - with "Import from Project Dump Folder" selected, browse and select the database you have exported 
   - Once the database and all tables are selected, click "Start Import" and now your openmrs-standalone database should be in your MySQL instance 
4. Deploy the openmrs.war file in Tomcat.
   -Once Tomcat is running, you can open Tomcat by typing localhost:8080  in your web browser
   - Click on Tomcat Manager (you may be prompted to enter your Tomcat username and password here)
   -  Under War file to Deploy, click on choose file In the Tomcat Manager
   - browse and locate the openmrs.war file you've downloaded from http://openmrs.org/download/ (Enterprise)
   -Click deploy in Tomcat manager now that the war file is visible
   -Once the openmrs.war file is deployed follow the startup instructions here making sure you specify that you have an existing openmrs database which you will use for this installation
5. Insert standalone Modules into 

Abbreviated version until I finish the detailed one above:

...

1. Copy your standalone Module files (.omod) into your enterprise application data folder at (C:\Program Files\Apache\Tomcat 6.0\OpenMRS) or any of the other locations documented at Application Data Directory

3- And of course you will need to update the openmrs runtime properties file in the application data directory to set the new connection URL, username and password for the new MySQL instance. 
Alternatively, after exporting the openmrs database, you could copy the war file from the standalone to your tomcat instance, rerun the installation wizard, when you get to the database setup page in the wizard, select that you have an existing database and set it to what you exported to the new mysql server instance. After the installation is complete, copy all the contents under the standalone's application data directory except for the runtime properties file to the new application data directory (The install wizard would have shown you this directory on its summary page). 

Related articles