knowledge base

By default, inFlow installs onto the main drive of your computer, 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 to another drive.  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)
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

4.  Run SSMSE in Administrator mode.  (You may need to right-click and select Run as administrator.)

5.  In SSMSE, connect to server name .\INFLOWSQL using Windows Authentication.

6.  On the object explorer at the left side, expand the server <SERVERNAME>\INFLOWSQL, then Databases.  Right click the inFlow database, then under Tasks, select Detach...
Click OK to confirm in the popup window.

7.  Repeat step 7 to detach the inFlowMeta inFlowSample database.

8.  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.

9.  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

10.  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), and replace the original program directory with the new program directory (it shows up 1 time).

11.  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.  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).

12.  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".

13.  Update your inFlow shortcut to the new location by right-clicking it, opening the Properties, and modifying the paths there.