Convert local database to cloud hosted mysql database

• bhim.rathor

  SSC Rookie

  Points: 44

  More actions

  January 21, 2017 at 6:23 pm

  #334268

  I have an application which is currently tied to the desktop application which will specific to each of my users.

  1.    The Existing application has about 300 table
  2.    The current database design is specific to a single user. For example , we for a given clinic as user , we have following tables

  •    Patient
  •    Patient_address
  •    Patient_Images
  •    Employees
  •    Clinic_details
  •    Devices

  3.    What I want is to host this database on web. I want to use this database for multiple users and need to be able to store and retrieve data on a user unique key(Let’s say user ID)
  4.    The database will be local as well as cloud based i.e. I would like user to continue work even if they do not have internet, and be able to sync it on demand when connection is back, I may also choose to run a nightly sync process on user desktop.

  What is the best strategy to do this? Currently I’m using MySQL, would it help if I switch to SQL?

  Any help in this is appreciated.

  Thanks
  Bhim

  P.S. - If this is not the right forum, please suggest the right forum for this question.