Difference between revisions of "FIELDPRO Database Management"

From MPSWiki
Jump to: navigation, search
(Created page with "FIELDPRO Database Management Overview File:Basic_Level.png File:Admin_Level.png The FIELDPRO System is intended for use by all users of all levels in every petroleu...")
 
 
Line 8: Line 8:
  
  
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.
+
Note: Platforms that have been tested in solutions provided to existing clients thus far have been based on a combination of Microsoft SQL Server 2014 and Oracle 12. 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'''.
 
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.''
+
''Note: There is a separate modules, the '''Migration Explorer''', 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 '''Migration Explorer''' 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 '''Migration Explorer''' for further information.''
  
  
Line 21: Line 21:
  
 
You will find information on how to install different typical network database configurations on both the server and client side.
 
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.
 
''
 

Latest revision as of 08:47, 29 May 2018

FIELDPRO Database Management Overview

Basic Level.png

Admin Level.png

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: Platforms that have been tested in solutions provided to existing clients thus far have been based on a combination of Microsoft SQL Server 2014 and Oracle 12. 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 modules, the Migration Explorer, 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 Migration Explorer 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 Migration Explorer 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.