Français

Can I download my database, and what can I do with it?

Modified: 2010/11/17 16:25 by slevesque - Categorized as: FAQ, Revision
This page is in the process of being edited, it may be incomplete or contain errors.

Your database (DB) is available at all times. You can download it and use it to produce your own statistical reports. The available DB is always the one from the previous night (the moment when the backups are done).

The DB is in the SQL Server 2005 format. To work with the DB, as a minimum you will need to install the free version of SQL Server 2005 called SQL Server 2005 Express Edition. If you already have an SQL 2005 server, you can install the DB on that server.

To install the SQL DB:

  1. Go to "Tools > Get database..." and save the zip file
  2. Move the saved file over to the computer where SQL Server 2005 is installed
  3. Unzip the saved zip file to extract a .bak file
  4. Start SQL Server Management Studio
  5. Use the function "Restore Database" to restore the .bak file into a live database. Consult this article to learn more about the "Restore Database" function.
  6. Once the database is online, you can explore its content with SQL Server Management Studio and you can create reports using tools like Excel or Crystal Reports.

Administration | This wiki was designed using ScrewTurn.