Exporting a spiceworks database

Posted by: David

Export your spiceworks database

I've had a few search queries hit my site looking for information on the spiceworks database.  Here is some key information:

• The database store all of the information you need for spiceworks
• You will want to stop running spiceworks before you attempt to export it
• Once you export the database, it should be exactly like the old one
• This will allow you to put a spiceworks database on a different server/computer with the same information it had before

What do you do?

In file explorer go to C:\Program Files\Spiceworks\db\ and find the file spiceworks_prod.db.

Make sure Spiceworks is closed and the service is not running.  You don't want anything manipulating the database file while you attempt to export it.

Once you have made sure that Spiceworks is not running, copy the database file locally on the hard disk renaming it as you please.

Once you have copied the database locally, you can go ahead and start Spiceworks up again if you need to.

Now you need to put the copy of your Spiceworks database file onto some media that you can transfer it to the computer that it will be going on.  Or just transfer it over the network.

When you are ready to use the database on the next computer you will need to already have Spiceworks installed.  Make sure the the program is not running and the service is stopped.

Browse back to C:\Program File\Spiceworks\db and replace the spiceworks_prod.db file with the copy of your database from the last computer.  You can do this by deleting spiceworks_prod.db and renaming the copied .db file to spiceworks_prod.db.

Start spiceworks and you should have all your settings and information copied over from the last computer.

It is that easy!

Tip for success

Make sure that anyone using or that is going to be effected by Spiceworks being down knows ahead of time that there will be a short down time in exporting a database.

Keep your stakeholders happy.