3f Software Planner project management move database

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.

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.

Move Server and Point application to use a database on a different server

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.

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.

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.

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.

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!

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!

move database, move to SQL server, move to Microsoft SQL server, move MSDE, setup installation, database server, db, moved db, different database