Question about DB Servers

Classic Servoy
1

Excuse me for being ignorant, but I do have this question:

When I look in the application preferences window, in the DP Servers section, I see more databases then only the Repository server (where I import all my solutions into).

How can I use one of these other databases and deploy a new solution on one of these?

2

Hi Karel,

  1. DO NOT USE THE SERVOY_REPOSITORY CONNECTION FOR YOUR SOLUTIONS!!

  2. You should ALWAYS use another database for your solutions.

  3. You can “access” these other databases by using a different “server connection” when creating your forms (it’s the top dialog box).

  4. You can create your own new database(s) and make your own DB connections as well. See the docs for more info on how to create a new DB and make a connection to it.

Hope this helps,

Bob Cusick

3

OOPS :(
Thanks Bob, but is it somehow possible to deploy/migrate the solutions that I made on the Repository DB to another DB Connection?

4

Hi Karel,

Yes - unless you used the “repository_server” connection for all your forms, etc. If you made up your own named connection and pointed it to the servoy_repository database, then we can fix it.

  1. Export your solution(s) to disk (File → Repository)

  2. Make a note of all the NAMED CONNECTIONS your soution uses (Edit → Preferences → DB Server

  3. DELETE your solution (File → Repository)

  4. Re-point (each) named connection to a different database (for example the one called “user_data”).

  5. Re-import your solution (File → Repository).

Your solution will now “point” to a different database and Servoy will automatically create the required tables, etc.

5

bcusick:
Yes - unless you used the “repository_server” connection for all your forms, etc. If you made up your own named connection and pointed it to the servoy_repository database, then we can fix it.

:( I did use the repository_server for all my forms and data… what options do I have?

6

In Servoy 2.5 you will be asked if you are sure if you want to import on repository server (to change from server you could ex-import once).
If you do have your solution on the repository server and want to change this, let us know and we sent you pre beta jars to overcome this.

7

Jan Blok:
If you do have your solution on the repository server and want to change this, let us know and we sent you pre beta jars to overcome this.

Thanks a lot Jan! My problem is solved! :D