Can We Put GBPVR.DB3 on a Drive Other Than C:?

[LewE]

I know we can configure GBPVR to put recordings wherever we want. I would like to be able to also put the GBPVR.db3 database on another drive. On the C: drive, it tends to get quite fragmented.

I have configured a small drive for data that gets very fragmented each day (e.g. the files associated with Thunderbird) and do a full defrag on that drive each night. I would like to put the GBPVR data base where it can easily be defragmented too.

Even if I do a complete defrag on C: nightly, the files there are of a nature where they cause many holes in the disk map and other files get very fragmented very quickly.

Since I'm pretty sure that the answer to my question is NO, would you add this to the Wish List?

[martint123]

It isn't limited to C: drive - sort of. Mine is on drive E: but that is the whole GBPVR drectory.
I know it has been requested in the past to have the database (and log) directory controllable (I'd like it this way for backups) ISTR that sub gave an indication the the imminent new version may have this facility. (I think it could cut down on Win7 protection support calls???)

[pcostanza]

I've always installed GBPVR on my D drive as well as all my programs and data. I keep my C drive for OS only. Never had a problem. If you're asking to have only your database moved to another folder, I don't see that being possible.

[LewE]

Putting all of GBPVR on another drive would work for me.

What do I have to do? A complete new install?

I will wait and see what the new version of GBPVR supports and then decide how ot move the program.

Thanks to both of you for getting me to realize that C: isn't my only option for installing GBPVR. I'll probably rethink all new program installs in the future and decide wherte to put them rather than just take the default C:

[martint123]

I have never moved it, I've always installed programs outside of Window drive C: so the below is a bit of a guess.

Backup the existing gbpvr directory completely !!
If your recordings are going to stay in the same place, then I think you can just move the directory to the same place on another drive (to play safe, I would include the full x:\program files\devnz\gbpvr structure).
There are no batch files by default, so any you have will be created by yourself or copied from others and will need checking.
Links in the start menu will need changing to the new location, possibly also in services.msc for the recording service.

I think if I had to do it, I would back it up, uninstall, reinstall in the new place and copy just the backed up database to the new location.

Hmmm - it might be worth waiting to see what the new version has

[ElihuRozen]

As a short term measure, you could download contig.exe from SysInternals. It allows you for defrag a single file. Go to http://www.sysinternals.com . (Don't worry when you get redirected to a Microsoft site, they bought SystInternals a while back.) While you're on their site, you might want to see some of the other useful freeware they have available. I highly recommend ProcessExplorer.

[pcostanza]

I would play it safe, backup as mentioned and uninstall then reinstall into your new directory. I think there's too much to go wrong trying to do a move but having never tried it, couldn't say for sure.

[LewE]

I would play it safe, backup as mentioned and uninstall then reinstall into your new directory. I think there's too much to go wrong trying to do a move but having never tried it, couldn't say for sure.

I would never just "move" an installed program because there would almost certainly be registry issues that would be a mess to try to patch up.

[stubright]

I moved my database file to another drive. You need to change part of the config.xml file and copy a couple of files across with the database.

The config needs altered to read something like this
<DatabaseConnectionString>Data Source="E:\GBPvr_DB\gbpvr.db3";Version=3;New=True;</DatabaseConnectionString>

You also need a copy of config.xml and System.Data.SQLite.dll in the same directory.

Make a backup first.

I hope that helps.

Stu

[LewE]

I moved my database file to another drive. You need to change part of the config.xml file and copy a couple of files across with the database.

The config needs altered to read something like this
<DatabaseConnectionString>Data Source="E:\GBPvr_DB\gbpvr.db3";Version=3;New=True;</DatabaseConnectionString>

You also need a copy of config.xml and System.Data.SQLite.dll in the same directory.

Make a backup first.

I hope that helps.

Stu

Thanks for the information. I realize that the log files should also bemoved ot reduce their susceptibility to fragmentation.

I think I will wait until the next version of GBPVR comes out. I will see what flexibility it provides.

At this point I think the cleanest approach will be to install GBPVR as a new install onto the other drive. I will save a copy of the current GBPVR directory before doing this (I usually zip the directory to make sure that it can't be altered by mistake). I have some BAT files (like postprocessing, etc) that I know will need editing but I feel pretty good after reading the replies to my original post that installing GBPVR on a different drive would not be that difficult.