How to install EMS server (MySQL Server for windows)

This guide will show you how to install the EMS server (MySQL server)

//We will make this guide Fast and Simple, so any average #computer literate individual can do this installation.👽👽

In order to run the EMS INVENTORY MANAGEMENT SYSTEM, You need to Install a running MySQL and PHP server, this guide will show you how. alright then! lets start by DOWNLOADING the needed files to run the EMS Database server.

Download Here

Download all 3 files.

After downloading, Install appserv-win32-8.6.0.exe
//Notice that the appserv is 32bit version? If you want the latest and 64bit version then you can always go to the official appserv website https://www.appserv.org/en/ and download the latest version of appserv. however we do not guarantee that it will work with our EMS INVENTORY MANAGEMENT SOFTWARE, You can always roll back to the version that is tested and working. 

https://www.appserv.org/en/download/ 

How do you plan to Run EMS INVENTORY MANAGEMENT SOFTWARE?

//Use EMS on a Single Computer

//Use EMS on Multiple Computers on the same Local Area Network                                                                                          

*Ubuntu Linux Server // if you want to use Linux as your server *FOR Advance Administrator only

// Install Appserv-win32-8.6.0 , on the installation process, you will be asked for root password, set and remember the root password as we need it in order to proceed to the Database restoration. we will need it for the ODBC connection setup.

// Install Mysql-gui-tools-5.0-r17. We will need this to access the server and restore the SQL Database

// Install Mysql-connector-odbc-3.51 , Also needed for the main EMS Software for database connectivity.

Now assuming all three (3) installations are done. to complete the server. it is now time to restore the database. download the SQL database and extract it. remember the path as you may need it later.

Setup Database (MySQL Server)

Download EMS Database // Restore this database to your EMS server using MySQL GUI Tools

To proceed to MySQL Database restoration, we created a Video guide for you to follow. Check the video below.

☝NOTE: EMS needs Microsoft Excel for exporting reports. Make sure you have it Installed on the computer you want to run EMS. as there are some reports that will be exported directly to XLS.

//EMS Pro - //The paid ver$ion, for distributor and large warehouse. 

Download EMSPRO HERE

//EMS Lite (UNDER DEVELOPMENT) - FREEWARE version, with limited feature but can run a simple small and mid-size retail business.

//xPOS - Point of sales system, connects to your EMS INVENTORY MANAGEMENT SOFTWARE