How to set the ServerName for a solution

Classic Servoy
1

Hi to all,
on Servoy developer 3,5 I made a postgres server in order to migrate from sysbase. I have configured right ServerConfig in DbServer.
Then I copied al the tables from user_data to new postgres db.

My problem now is how to do for setting the Solutions that worked with ServerName user_data in order to working with ServerName new postgres db.

Is another wy than to select a form per time and to change the ServerName?

Tanks in advance.
Gianni Pinna.

2

In Servoy 5 you can rightclick your active solution and do “Replace server”, but I’m not sure if this functionality existed in 3.5.

Another way that can be done in 3.5 is this:
If you import a solution in developer and the database connection doesn’t exist, you get a dialog to choose another database instead, so you should just disable/remove the user_data connection and do an import. If you then get the dialog, you should choose the new postgres db.

3

Hi Joan,
tank You very much,but a new problem.

I have arrived to Your solution after theese steps that Kindly as You Karel Broer suggested me from another way:

  1. Make sure you have set a form on each table that you want to migrate.
  2. Export your solution with sample data and i18n keys
  3. Delete your solution (in 3.x from the Repository dialog or in 4.x > from the solution node)
  4. Disable the example_data connection
  5. Restart your Servoy Developer
  6. Import your exported solution again
  7. Servoy will ask for an alternative db server, because the example_data server is disabled
  8. Choose whatever db server you like
  9. Done```

THE PROBLEM NOW IS: 

after having:

A.) "7. Choose whatever db server you like"

B.) and resolved some field conflict problems between Servoy and postgresql

The import solution was loaded without any error message, 

but " THE SOLUTION NAME DID NOT APPEAR UNDER REPOSITORY".

Tanks in advance 

Gianni Pinna