Moving backend DB's?

Classic Servoy
1

I’ve been working with Servoy all on my own OSX machine. I moved my MySQL databases over to our Web server where they will normally reside. When I went to the database definitions and pointed Servoy to those databases, it pretty much broke everything. Some stuff was easy to fix, but the relationships had to be completely deleted and re-created before they would work again.

I’m going to need to move databases back and forth between my system and our webserver as I do development work. I can’t keep re-defining half the Servoy database every time I move it.

Any good ideas on how to move my databases and development environment back and forth without a lot of work re-defining things in Servoy?

2
  1. on local machine, export your solution (FIle>Repository)
  2. on Local machine open admin page of Servoy server with url>
    http://“servername”:“port”/servoy-admin/
    where “servername” and “port” are your variables.
  3. click on Solutions>ImportSolutions and browse to your solution file.

A new release will be created on the server.
notes:

  • You can go back to previous release.
  • Changes done on local database will also be done on server database.
    (except for dropping objects, otherwise previous releases might not run anymore.)