Directory Sizer 2 - Database Move

How to move the database to a new machine

1. If you have not already done so, install SQL Server 7, 2000 or MSDE on the new machine. If you need MSDE, you can download it from the downloads page.
2. Using the Directory Sizer Setup program (see downloads), install a fresh database, and install the Directory Sizer Central service.
3. Stop MS SQL Server service on both machines. If the SQL Server machine is a database server for other applications, you will need to do this during downtime.
4. On the old machine, deinstall the old Directory Sizer Central service: click on Start, Run, and enter

   dszCentr -remove

5. Copy the dszDB_Data.mdf and dszDB_Log.ldf files from the old machine to the new machine, replacing those on the new machine. By default these files were placed in a folder called DirSizerDB off the root of the disk with the most free space.
6. Start SQL Server on the new machine.
7. On the old machine, either start SQL Server, or if no longer required, disable it through Services, or deinstall it.
8. On the new machine, run fixPasswords.exe and enter new passwords for the web SQL logins.
9. On the Directory Sizer web server, edit dszWeb\include\dszConnection.asp and change pwd=whatever1 to pwd=yournewuserpassword.
10. Edit dszWeb\admin\dszConnection.asp or dszWeb\admin\dszConnectionA.asp depending on which exists on your system, and change pwd=whatever2 to pwd=yournewadminpassword.
11. No action is required on the remote Directory Sizer Scanner machines.