Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
relocating server/data to a new computer |
Mon, Mar 21 2011 2:25 AM | Permanent Link |
Lucian | 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 |
Mon, Mar 21 2011 11:24 AM | Permanent Link |
Uli Becker | 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 |
Mon, Mar 21 2011 4:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Mar 22 2011 7:11 AM | Permanent Link |
Lucian | Thank you very much,
Lucian |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |