Hi,

It has been asked here at least once how to change a database path but never what's involved in moving a database and the server. My situation is this:

Until now all development was done in house and I'm running C/S unicode edition. Me and a customer are accessing data in C/S mode.

Now I want to move the server and a database to a different computer (another country, more precisely) and we want to keep the data we already have in the database..

What are exactly the steps to do this? I suppose it's something along this lines:

1. install server on the new computer
2. add edbsrvr.exe in the firewall exceptions list
3. edit server options and setup a configuration folder and a temp folder (I never did any "Customizations", so I'll leave that)
 - assume, for instance: C:\DATABASES\EDB
 - and D:\TEMP
4. run edbmanager and create required user(s) - not sure if needed at this point

And this is where I get lost. I am going to zip the database files and send the zip to the customer. he is going to unzip the files, let's say under C:\DATABASES\EDB\MyDBFolder\

what is the next thing I have to do in order to correctly install the
existing files?

Currently I keep all my edb databases under Q:\DATABASES\ELEVATE\EDB and this is the folder where the server configuration files (EDBCfg and EDBLog) are located.

Second issue, extremely important. I have noticed the database is quite big, reaching (during development) almost 1GB and I think I want to enable Large File Support on customer's site. Please add to the equation.

When I will zip the database, I will drop first this one particular table that is going to be huge, but there is other data we want to preserve.


regards
Lucian

Lucian,

> What are exactly the steps to do this? I suppose it's something along this lines:
>
> 1. install server on the new computer
> 2. add edbsrvr.exe in the firewall exceptions list
> 3. edit server options and setup a configuration folder and a temp folder (I never did any "Customizations", so I'll leave that)
>   - assume, for instance: C:\DATABASES\EDB
>   - and D:\TEMP
> 4. run edbmanager and create required user(s) - not sure if needed at this point

It's quite simple from here. Just copy the folder with the physical
table files (*.EDBTbl, *.EDBIdx and the catalog (very important!)
*.EDBCat to the new database directory on your server.

Then open edbmamager and create the databases as you did before on your
old machine.

New let the clients connect to EDBServer just by using the new IP or the
new host name and you are done.

Regards Uli

Lucian,

Uli's answer is exactly correct - once you have their configuration set up
properly, just copy the database directory contents from your machine to the
target database directory on the other machine.  If the other machine's
database directory already has a database catalog in it
(edbdatabase.edbcat), then just overwrite it with the one being copied.

You can choose to create the database using CREATE DATABASE before the copy,
or after the copy.  The only thing that really differs is that if you do it
before the copy and open the database at any point, then you're going to
have to overwrite the existing edbdatabase.edbcat database catalog as
described above.  The catalog file for a database is automatically created
(empty) when the database is first opened, unless one is already present.

<< Second issue, extremely important. I have noticed the database is quite
big, reaching (during development) almost 1GB and I think I want to enable
Large File Support on customer's site. Please add to the equation. >>

No changes to the files are necessary to enable large file support.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thank you very much,
Lucian