FIELDPRO Database Management
FIELDPRO Database Management Overview
The FIELDPRO System is intended for use by all users of all levels in every petroleum exploration and production enterprise in the world. This is an ambitious project that requires a very sophisticated level of networking and communication. It is for this reason that cutting edge database technology is at the heart of the system.
Note: FIELDPRO is intended to support all ODBC database sources. Platforms that have been tested in solutions provided to existing clients thus far have been based on a combination of Microsoft Access 2000 and XP, Microsoft SQL Server 2000 (SP4) or 2005, and Oracle 8.1.5-7 or 9 or 10. We can implement support of any other standard ODBC database upon request, and it is our express goal to make sure that clients achieve complete data integration.
This section of the documentation of the system will cover all aspects related to management of FIELDPRO Data Sources.
Note: There is a separate application, the FIELDPRO Migration Manager, related to Check-In Check-Out functionality, which allows you to download a subset of a FIELDPRO data source to separate FIELDPRO database (e.g., so that you can take this information to the field), and then you can make updates in this separate database and upload these changes to the original data source. This FIELDPRO Migration Manager is also dedicated to importing and exporting (migrating) mass data between FIELDPRO data sources and other mass data sources (i.e. other database systems supported by the application). Please refer to the documentation for the FIELDPRO Migration Manager for further information.
We begin with information related to the selection of a data source when logging into the program, and the organization of data sources in general in the program.
Next, you will find sections relating to the installation of database systems, creation of new databases, and configuration of connections to those databases, as well as backup, restoring and upgrading database versions.
You will find information on how to install different typical network database configurations on both the server and client side.
Note: Microsoft Access does not properly support multi-user network access. We do not recommend that Microsoft Access is used as the basis for a shared database system, although, as below, there is a great deal of functionality in the system to allow you to use this database system to communicate and share information.