Create a Project Database

This page describes how to create a 'project database'. The process copies all data associated with one project to a separate database file. Unlike an export file this new database is a fully working StrataBugs database with all links to dictionaries, groups and charts in place. You could, for example, extract a project database for use at wellsite. You could also use it as an alternative to SBG files when distributing data to clients.

To start the process, select the project and press 'Create DB' on the Wells Main Window.

Running notes

Note that if you are connected to a multi-user database with the background data refresh task running, you will need to disable this feature before you can create a new database (go to Control Panel | Config | Set data refresh rate).

You will have selected a project before opening the dialog. You must select a database file in which to copy the project. This must be an empty StrataBugs v2.1 database. If you try to combine existing data (you will be warned), the results are unpredictable.

You can download a fresh template database for H2 here or for Access here. If you do not rename this file sbugs2-0.mdb, a new file will be created as a copy of this file, with the project name appended to the file name, thus the template file sbugs2-0.mdb will be left in its original state.

You can copy to either type of database regardless of the type of your current connection. For v2.1 onwards, H2 is the default database type for standalone (single file) databases. Any StrataBugs user can connect to either type of database; however you should note that the legacy charts module will not work with an H2 database. Please feel free to contact StrataData if you are unsure which database to use.

The process of copying the data from your database into the new database will begin immediately, and proceed to completion if there are no errors. When complete, you can test the new database by returning to the Control Panel and selecting Change database from the File menu.

Be sure to change back to your main database after testing.


Page last updated: 01-Dec-2014 9:41