Can I install inFlow to another drive?

By default, inFlow installs onto the main drive of your computer (the one that houses Windows), typically the C drive. The main reason we don’t offer a choice is that SQL Server, which inFlow uses, must be on this drive. However, it is possible to move many of the parts of inFlow v2 to another drive.

If you are using inFlow v3 or the latest version of inFlow, the following steps are not possible to do at all.

This is quite complicated, so it’s only recommended if absolutely necessary of if you’re an IT professional administering a server. We’ll be moving the program folder of inFlow to another drive, then detaching the database files from SQL Server, moving them, and re-attaching them there.

  1. If you already have inFlow installed, make a backup of your database. If not, download and install inFlow onto your server. This will install inFlow onto the main drive. Shut down inFlow.
  2. Move the directory ‘inFlow Inventory’ from your Program Files directory to your target program directory.
  3. Download and install Microsoft SQL Server Management Studio Express (SSMSE)
  4. http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
  5. Run SSMSE in Administrator mode. (You may need to right-click and select Run as administrator.)
  6. In SSMSE, connect to server name .INFLOWSQL using Windows Authentication.
  7. On the object explorer at the left side, expand the server INFLOWSQL, then Databases. Right click the inFlow database, then under Tasks, select Detach…
  8. Click OK to confirm in the popup window.
  9. Repeat step 7 to detach the inFlowMeta inFlowSample database.
  10. In Windows Explorer, open the directory where inFlow’s database files are stored. On Windows XP or Windows Server 2003, this is usually at C:\Documents and Settings\All Users\Application Data\inFlow Inventory On more recent operating systems, this is usually at C:\ProgramData\inFlow Inventory\Backup.
  11. Move the following 6 data files to your target data directory: inFlow.mdf, inFlow_log.LDF, inFlowMeta.mdf, inFlowMeta_log.LDF, inFlowSample_log.LDF, inFlowSample.mdf
  12. Open your target program directory, then edit attachDB.sql to search and replace the original data directory with your new data directory (it shows up 6 times, so you’ll need to make sure you make 6 replacements total).
  13. In the same directory, there is another file named “UpdateCLRObjects.sql”. Open it and edit the original program directory to your target program directory. This should only show up once in the file at the very bottom.
  14. Shut down SSMSE and any other programs that might be accessing your database. Then, run inFlow by double clicking on inFlow.exe. This should bring up the Troubleshoot Connection window.
  15. Click the Fix the problem for me! button. This will reattach the inFlow databases using the attachDB.sql script we edited in step 10, then start inFlow.

    If you have problems here, you can try detaching the databases once more – steps 4-7 – and then attach again in step 10. You can also try attaching the database by running the contents of the attachDB.sql script in SSMSE (click New Query after connecting).

  16. Turn off auto-backup (which currently can only backup onto the C drive) in inFlow by clicking Main Menu (round button at the top left) -> Settings -> General Settings -> Auto Backup and setting it to “Backup every 0 days”.
  17. Update your inFlow shortcut to the new location by right-clicking it, opening the Properties, and modifying the paths there.
Yun Ling
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
April 7, 2017