Applies to
Server version 3.1000.0009 or above
Topic
Moving the
database from one server to another. The method in this article applies to
both MSDE and Microsoft SQL server. However, if you have Microsoft SQL
server, it may be faster to make a backup using the Enterprise Manager and
then restore the database on the target database server. This article is
primarily designed to enabled users who do not have a Microsoft SQL server
to move the location of their database.
Prerequisites
The sever where
you will be moving the database to (the destination) must have either MSDE
2000 SP3 or Microsoft SQL server 2000 installed. MSDE 2000 database engine
works fine with 15 - 25 concurrent users depending on usage.
See also
Move Server
and Point
application to use a database on a
different server
Article
In the 3f Software
Planner there are two core components: the program and the database. You
can set up the database and program on the same server or you can have it
on two different servers.
This paper
discusses how you can move the database. Moving of the database takes
place after the 3f Software Planner installation. In other words, if you
know from the outset that you want the database and program on two
different servers, then you must install 3f Software Planner completely on
the program server before you move the database!
ALWAYS REMEMBER TO BACKUP YOUR DATABASE BEFORE YOU MOVE IT!
To see how,
click here (Follow step 1
- 5 only)
You can download
the free MSDE (Microsoft Desktop Engine) from:
http://www.microsoft.com/sql/msde/
If you want your
database behind a firewall and the IIS server outside the firewall, you
must open port 1433 (or whichever port you use) to allow the SQL server to
be seen from the IIS server before you attempt to move the database.
How the tool
works
The tool requires
you to identify the computer where the database is located (the source),
then you have to identify the computer where you want to move the database
(Target). When that's done the tool stop the web site where 3f
Software Planner is running, copy the database to the target computer,
change a registry setting so that 3f Software Planner knows where the
database is installed before it restart the 3f Software Planner.
In the last step, once the copying has been finished, you have the option
to delete the source database.
Step 1.
When you have
verified that either of the two database engines are installed and
properly configured start the Database Transfer tool found in the 3f
Software Planner program group. Upon confirmation that you want to move
the database you will be taken to a form where you choose the source
database you want to move. (see image below)
At first it may
seem strange that you have to choose a source database. The reason is that
you may want to move the database from one database server to another
database server, hence you need to be able to identify the database
source.
If the source
server you need is not listed in the combo box under SQL/MSDE Server then
try to enter the i.p. address. Also there may be more than one instance on
the database server, be careful to choose IPLAN2005!
Note: If you
cannot see the source server then you may have a firewall (software or
hardware) preventing you. Close this program, turn off the firewall, then
try again.
Step 2.
When you have
entered your source details click the Next button. In the next step you
choose the target server which is where you will move the database to.
(See image below) The data you enter here are pretty much the same as the
data above except they pertain to the destination database.
Note: If you
cannot see the target server then you may have a firewall (software or
hardware) preventing you. Close this program, turn off the firewall, then
try again.
Step 3.
When ready, press
the next button. If the destination database server already has a 3f
Software Planner database you will be presented with confirmation message
box. (See image below). Click yes to overwrite the destination database.
Step 4.
Next, press the
"Copy" button to start the moving of the database. The database is
actually copied to the destination server. Next a registry entry is
modified so that the program uses the database on the database server.
Once the copying
function is finished you have the option to delete the source database.
This process can take some time and there is no visible notification that
the copying is taking place!
Step 5.
When the database
has been moved you have the option to delete the source database by
checking the appropriate checkbox and then press the close button.
DO NOT DELETE THE SOURCE DATABASE UNLESS YOU BACKED UP YOUR DATABASE!
Keyword
move database, move to SQL server, move to
Microsoft SQL server, move MSDE, setup
installation, database server, db, moved
db, different database
