Question Locked

MP2 6.1 SQL Server 2005 Express Edition

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to upgrade an Enterprise Asset Management (EAM) application using a MS Access database to MS SQL Server 2005 Express Edition. The upgrade and data conversion has already been tested on a stand alone computer and everything is "Go".

However, there is concern by some stakeholders about installing and running the application database using SQL Server 2005 Express Edition on the same server or even the sam Local Area Network with other critical business applications that still uses MS SQL Server 2000.

The EAM users do not use the other business applications and there is no integration existing between the systems. Migrating all business systems up to MS SQL Server 2005 or migrating the EAM application to MS SQL Server 2000 are cost considerations that cannot be entertained at this time.

I believe the both databases and applications can run safely on the LAN. Can you give me some information that will reinforce my position.

4 replies

by mfox

We are planning on migrating from MP2 Access 2000 to MP2 SQL 6.1 (Express version) next year. The Access version will not be supported on MS Vista so we are planning on the upgrade in case we move to Vista (Not unless we are forced to by hardware failure and replacements).

How did your mogration work? Were there any problems? We have two treatment plants running MP2, and there are many others here in Michigan also using MP2.

Thanks.

by roelof

Hi,
The company I work for (www.mainguard.co.za) specialize in support of the MP2 applications in South Africa. We are not the primary vendors, but we give support to our clients. To upgrade from Access version to 6.1 is actually 3 steps.
You need to set up your sqlserver 2005, install 6.1 (include all the warehouses, purchase centres,site, etc). Then go to tools-utilities-convert from anothe product.
Select the access version and magic..... Some area codes and meters it does not upgrade quite good, but it gives you a variance report after the upgrade so you can adjust on the new system.

If you have any difficulty, please e-mail me at roelof@mainguard.co.za, i will be able to assist (just keep in mind the time diffrence)

by luis_mariel

MP2 fro SQL2005 (version 6.1) can not work in a server with SQL2000. At the moment you try to install, SQL2005 will convert any database existing in 2000 to 2005 format.

If SQL2000 is in a different computer, you should not have any trouble.

You can contact Infor Support and they will help you with more information.

This discussion is closed to new replies.