Move a Solution to different DB Server

Classic Servoy
1

I have solutions in DB Server ‘user_data’.
I want to move my solutions to a newly created DB Server ‘my_server’ in the same Servoy-Server.

How do I achieve this migration ?

I cannot see a way to achieve this from the Repository view (nor the DB Server view).

Does that mean once you create a Solution in a given DB Server you are stuck there for life ??

The only solution that seemed possible is to grep ‘user_data’ and replace with ‘my_server’ on an exported version of the original user_data solution, and then re-import. I haven’t tried this becasue it may be dangerous.

My motivation for needing to do this is a naming conflict with 3rd party tables in the ‘user_data’ DB Server.

2

I don’t quite understand what you want to achieve.

What do you mean by “I have solutions in DB Server user_data”? Do you mean you have user data there that you would like to move to a different database? If so, the solution is simple: export your solution, disable the user_data server, make sure you have the new my_server server available, and reimport. The import will complain that it cannot find the connection “user_data” and it will ask you if you want to use a new server instead; select my_server, and you’re done.

Changing the import file by search/replace will not work because it will generate a CRC error and the import will fail.

3

I don’t quite understand what you want to achieve.

Your answer to the question provides a very workable way to achieve what I want.
So, I think you did understand well what I wanted to achieve :)

The solution you offer is guaranteed to work, by the sound of it.

But, 2 things:

  1. it’s a workaround and requires an experienced product user to find that solution to the problem (imho, the application should offer that style of functionality)
  2. your process appears to be undocumented (at least in the docs I read)

But, I’m happy :)

thanks

4

Hi,

I’m glad I understood you correctly and was able to give you a working solution. The advantage of this way is that using the “sample data” feature you can move the database from one server to another.

I just remembered there is another way to do this, which does NOT do anything except switch the server connection (or even tables). This means that the tables must already exist in the new server, as well as the data. To do this go to the repository dialog and use the “Replace Table” option. To replace all the tables from one server to another just select the source server, “-All-” for the source table, and the target server.

5

Thanks for the great tips !

Very useful advice.