At the moment I’m migrating my Servoy environment from 3.5 to 4.1.3
I need to copy the users from 3.5 to 4.1 with keeping the same Servoy User-id
How can I do that?
Hi Martin,
One quick method is to let Servoy 4 to upgrade your repository. Of course this would make the repository no longer usable for 3.5 so I suggest you copy the db (and rename it when used side by side in one server).
Hope this helps.
Hi Robert,
Unfortunately my repository database has already been created, but I still have the 3.5 database
I copied the table servoy_users from 3.5 to 4.1 database.
Normally you should not do this, but I don’t use Servoy groups / form security, so I tried it and it seems to work. I got even the passwords like this.
Kind regards
Martin
Did you try to export the solution from 3.5 including users and import in 4.x? I’m not sure it the IDs will stay the same but it’s worth trying.
Yes I tried, but for some reason that doesn’t work:
- Not all my users are copied. When I linked my repository-server to the live-environment and I made an export, then I could make export of a solution, but the users were from my local development (maybe a RMI-port 1099 issue ???)
- When I had users linked to an usergroup and those users were imported, then those users were not imported because of “group does not exists”. I expected that groups were created also
I made a copy on database level. I imported the user-table from 3.5 repository into 4.1 repository. And that seemed to work.
The group problem was not an issue for me, because I didn’t need those groups.
Servoy support also wrote me about this:
The userid is primary key, so in order to do this, you’d have to do this on database level, so outside Servoy.
But, why should the userid remain the same? Inside Servoy everything is done on User UUID, which is freely defineable and should be automatically be exported and imported when you include the users when exporting/importing a Servoy solution
Servoy support
So the problem is solved now.