Our has been ported from 3.25 to 4.47. implication is of course that the dbsrvr has to be upgrade, too.

We now stop srv 3, remove it, install srv 4, start it and fill it with the necessary data (database, users, etc). Everything manually. With more than 600 customers that is a lot of handwork.

Question: is there any way to automate this process? For instance: export a srv3 regkey and import it in srv4?

Kees


I never used c/s with DBISAM but I do know that the ElevateDB version uses an ini file and looking at

https://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=configuring_starting_server

so does DBISAM.

You'll need to check for differences between the two versions but it "should" be a simple matter of copying and editing the ini file.

Roy Lambert

On 4/30/2020 5:36 AM, Kees Lagendijk wrote:
> Our has been ported from 3.25 to 4.47. implication is of course that the dbsrvr has to be upgrade, too.
>
> We now stop srv 3, remove it, install srv 4, start it and fill it with the necessary data (database, users, etc). Everything manually. With more than 600 customers that is a lot of handwork.
>
> Question: is there any way to automate this process? For instance: export a srv3 regkey and import it in srv4?
>

I have not used dbsrvr3 for years so don't recall it had but v4 does not
use registry at all AFAIK - server core config is in INI (ports,
enryption, etc) and databases,users etc are in the server config file
normally (dbsrvr.sfc normally)

As to automatic creation of databases, users etc there are few things

1. If these are always the same then just include a config file when
installing server or copy it into the folder before starting it.
if you database folders are always same you can hard code those or if
there are relative to server you can just use relative paths.

Worst case you have to manually adjust few paths are and such.

2. Alternatively this all can be done from code using either local
engine connection or remote admin connection (i'd use that) so you can
write a small install utility that connects and adds databases, users etc.

Basically for remote admin connection you can use

AddRemoteDatabase, AddRemoteUser , AddRemoteDatabaseUser etc - there are
large number of these to configure all aspects

All those functions are part of Session

https://www.elevatesoft.com/manual?action=viewcomp&id=dbisam4&product=rsdelphiwin32&version=10R&comp=TDBISAMSession

Raul