Introduction to migrating data from previous versions
The structure of the databases of previous versions of the MP is not compatible with version 10 of the MP, so you will not be able to access them automatically.
If you are a version 9 user and you want to transfer the information from your previous databases to the new version 10 database structure, you must carry out the migration process described below.
When performing the migration of databases, you will pass all the information that you have handled so far in MP version 9, such as catalogs of equipment, locations and buildings, maintenance plans, labor, suppliers and services as well as auxiliary catalogs, equipment maintenance histories, work order history, readings and measurements.
Our recommendation to know the environment and the new way of operating the program is that you first use the database of examples. Once you are familiar with it, go through the migration process for your old databases.
How do I migrate the information from my version 9 to 10?
For migration, it is recommended to install MP version 10 on a computer or workstation where the MP CLIENT version 9 is installed.
This is recommended so that, when carrying out the migration, MP version 10 finds the accesses to the databases that you created in your version 9.
You will be able to install MP ver. 10 even in the same folder where version 9 is. This will not affect the operation of the applications at any time.
It does not matter which Database manager (Access, SQL or Oracle) you are using in version 9. When you go through the migration process to version 10 you will be able to choose a new Database manager.
The migration process must be carried out for the databases of the different applications of the MP suite of programs. (MP, Inventory of Spare Parts, Tool Control and Request Manager).
When running any of the MP suite programs
Select the option “Migrate databases from MP version 9"And click the"Next"
Then choose simplified option or advanced option, as the case may be.
This option is recommended to migrate MP version 9 databases that you have created in Access, passing your information to Firebird databases on your local computer, that is, on the computer where you are carrying out the process. This option is useful if you are not familiar with managing database servers and engines and do not intend to share your database with other users. However, note that this option applies only to version 9 databases created in Access, creating a new database for version 10 in Firebird locally on the computer where the process is running. If you don't have Firebird installed on your computer, MP will send a message requesting permission for its installation and, if applicable, it will install the Firebird database engine automatically. Actually, this process is very simple and does not require further explanation other than following the steps that will appear on the screen.
This option is the one you must choose if you are going to share your databases in the cloud or on your company network with other MP users.
The MP version 9 databases that you have created in any of the following engines:
- Microsoft SQL-Server
You can migrate them to any of the following database engines:
- Microsoft SQL Server
In addition, the databases that you migrate can be hosted in:
- User's PC
- Virtual teams
- All types of networks (Wan, Lan, Wlan, Vlan, etc.)
- Servers or webhosting of your preference
If you selected the simplified option, only your databases in Access format will appear, but if you selected the advanced option, all the version 9 databases that you have access to from that computer will appear. If any of them have already been migrated before, the window will show the date the process was carried out.
Advanced option for cloud or network database migration
If you have a network in your company, most likely they already have one of the MP-compatible database engines installed on their servers. If not, before continuing with the creation of a database, it is necessary to install and configure one of the database engines compatible with the MP.
Your IT department or systems will be able to advise you on the database engine they use and indicate the location for the database, according to the infrastructure and IT policies of the company.
Before proceeding with the migration of your databases, it is important that you take into account certain particularities that you must configure depending on the database engine that you are going to use.
Click on the following links to learn more about the settings required for your database engine:
If you did not hire the cloud hosting service MPcloud o MPhosting, it is important in this part of the process to request help from the company's IT staff, since it is necessary to have permissions on the hosting server for the database and especially knowledge of the connection data to the server
Once you have considered the above and made the appropriate configurations in your database engine, select from a combo the type of database engine where you want to migrate your information from version 9. (Firebird, SQL, MySQL, MariaDB and Oracle)
After selecting the server type, provide the IP address of your database server or server name where your MP database will be located. What is this?
In the next two fields write down the name of a user and password with permissions and privileges to create the database in the selected engine. For more information, see What is this?
In the last field write down the name that you will assign to the database. See characters and allowed length.. By pressing next, you will have another field of up to 50 characters that will allow you a broader and more complete description of the database.
Note for MPcloud or MPhosting:
In the event that you have contracted the service MPcloud select MySQL server type, and in case you have hired the service MPhosting, select MySQL server type. Regarding the location of the server, username and password that are requested in the previous window, the MPsoftware team provides you with this information in your purchase detail, which we send you at the time of contracting the service.
In the event that you want to host your database on a server in the cloud or web hosting of your preference other than MPcloud o MPhosting, you can also do it. Most web hosting service providers include the MySQL database engine. Consult your service provider who will be able to tell you if your contracted service includes a database engine, as well as the server's IP, username, password and data storage capacity.
When you migrate, a new database is created. By default, MP proposes a name equal to that of the version 9 database plus the _m10 characters. For example, if the version 9 database name was PLANTA_SPEREN, the default suggested new database name is PLANTA_SPEREN_m10, however that name is editable.
Similarly, by default, MP suggests the same name of the access to the database, putting the words ACCESS A before it, however, it should be mentioned that the name of the access is also editable.
It is the name that you will assign to the new database
See characters and allowed length.
|Name of the access to the database
Refers to the name of the Access to the Database
What is this?
|Long description of the database
Refers to a long description of the database
|PLANTA_SPEREN_1_m10||ACCESS TO PLANTA_SPEREN_1_m10||SPEREN PLANT INDUSTRIAL PARK EXPORTEC II|
Participate in our help forum
Leave a question that you and others may have and allow our Technical Support team to answer it publicly.