|
Question:
How do I transfer data from one server computer to another?
Answer:
It is common
for clients to first install ExpressMaintenance on a single PC
during the evaluation period. When the client purchases ExpressMaintenance,
they are ready to install it on a network server. However, they
often realize that they have entered valuable data and would like to
retain the data. You can transfer the data to the server by using
the following steps:
-
Make
sure you have the latest release of ExpressMaintenance
installed on the evaluation PC or source computer.
-
In ExpressMaintenance on the PC, click Navigate / Administration
/ Backup & Restore.
-
Backup the
database to a zip file, noting the file and folder names (Backup
Tech Bulletin).
-
Copy
or transfer the zip file to the new server computer.
-
Install
and start the MSDE on the server computer if not already installed.
If using your own version of MS SQL Server, see tech bulletin for
setting up database - click here. If you are using Windows2003 you will need to
install MSDE2000 - click
here for details.
-
Install
the latest release of ExpressMaintenance on the server
computer.
-
It is important that the same version be
on the origin and destination computers.
-
If you have
existing ExpressMaintenance data on a prior server, you can copy
your original data files from your older server to overwrite the
model files. The original data files can be found on your
prior server in the 'Program Files\MSSQL\Data '
folder(SQL2000) or 'MSSQL7\Data' folder (SQL7) . Copy the data
and log files to the ExpressTech folder and they will be used to
create the database. If this is done successfully, you will
not need to perform remaining steps below.
-
Run ExpressMaintenance on the
destination server computer to create a new
database (first time). The new database will be setup as
an evaluation copy and prompt for a serial number and registration
code. Ignore this as the serial number and registration code
will be obtained when you restore the data.
-
In ExpressMaintenance on the
destination server, click on Navigate /
Administration / Backup & Restore.
-
Restore
the database from the zip file as previously saved on the server
computer. Note that the zip file must be on hard drive of the
destination computer. It cannot be on a remote drive, zip drive or
CD as it must perform decompression before restoring.
The restore zip file must be on the new server computer in order to
perform the restore.
Reinstalling On Different Computer
If
you are installing ExpressMaintenance on a new or different server,
you should follow the steps above as well. The serial number
and registration code will be restored when the data is restored.
If you have lost the original data, you must email
support@ExpressTechnology.com
with the new serial number and a your company name. A new
registration code will be issued and emailed to you.
Alternative
You can use the
ExpressUtility program for performing backup and restore functions.
The ExpressUtility install (EUInstall.exe) is found on the CD or can
be downloaded from our website -
Download
ExpressUtility. |