trying to upgrade repository from 2.2.4 to 3.1.6

How does Servoy know where to look for the previous version repository? I have version 2 of Servoy installed in directory 'Servoy', and have installed version 3 in a new directory 'Servoy3'.

I have copied the servoy.properties file from 'Servoy' into 'Servoy3'. My backend database is in MySQL, but the servoy repository runs on the default setting in Sybase. On opening developer in Servoy3 there is an error message "Can't connect to the repository server specified in the application preferences", so in preferences I change the driver for the repository_server from 'com.sybase.jdbc2.jdbc.SybDriver' to 'com.sybase.jdbc3.jdbc.SybDriver' (I don't find this step mentioned in the instructions).

Now when I open developer in Servoy3 (version 3.1.6) I get the message "Cannot find a repository on current 'repository_server' connection, do you want to create a repository?'. According to the instructions it should update the old repository, but it doesn't seem to know where to look for it.

I have tried creating a new repository and importing the solutions from version 2, including the users, but the result is that the users are created in version 3 in a random order, so the user ids are different between the two versions. As I use the user ids in the solutions, it would be a considerable amount of work to change them all in multiple solutions.

How can I tell Servoy where to look for the repository? Also, when I have several installations of Servoy on the same computer, how can I tell the update to use the correct original repository? For example on the server we have one installation which is live, and another which is a testbed.

Any suggestions appreciated, our 'live' server has been off line for several days now trying to upgrade from 2.2.4 to 3.1.6.

Hi Gudrun,

Is Sybase running at all?
Check if there is a process named 'dbsrv9' running. This is Sybase.

Also this can be the Sybase instance of Servoy 2.2 or the instance of Servoy 3.1.x.
My suggestion is to close/kill all dbsrv processes and then copy the db file (including the .log file) to the Servoy 3 installation.
Then launch Servoy3 and it will/should open the correct Sybase instance with the copied repository database.

Hope this helps.

Hi Robert,

Thank you very much, this did the trick!

'dbsrv9' was indeed running. I stopped it and copied the files as you suggested, and now the repository has updated exactly as I was hoping for.

Thanks again, I appreciate the quick response.