This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Dear all,
Someone has migrated a Maximo database 7.1 of IBM DB2 to MS-SQL Server?
I have a customer who needs to upgrade from version 7.1 to version 7.5. But he also wants to change the database from DB2 to SQL Server.
I think the best way would be to migrate the database to SQL Server and after perform the upgrade. However, there are several settings in TPAE concerning the DBMS, such sequences, triggers, etc ...
Perhaps the best way would be to install a CORE product in version 7.5 and migrate data from IBM DB2 to SQL Server using the maximo integration framework (MIF).
Let me know what you think about ...
Thanks, Elberte.
Hi,
Back before 4.1.1 we moved from SQL Base to SQL Server. At that time PSDI (later renamed MRO then purchased by IBM) sold conversion software. Maybe IBM has some software.
You could try what you suggested.
Dave Bone
--- In MAXIMO@yahoogroups.com, Elberte Pongelupe <epongelupe@...> wrote:
>
> Dear all,
>
> Someone has migrated a Maximo database 7.1 of IBM DB2 to MS-SQL Server?
>
> I have a customer who needs to upgrade from version 7.1 to version 7.5. But he also wants to change the database from DB2 to SQL Server.
>
> I think the best way would be to migrate the database to SQL Server and after perform the upgrade. However, there are several settings in TPAE concerning the DBMS, such sequences, triggers, etc ...
>
> Perhaps the best way would be to install a CORE product in version 7.5 and migrate data from IBM DB2 to SQL Server using the maximo integration framework (MIF).
>
> Let me know what you think about ...
>
> Thanks, Elberte.
>
>
>
One thing worth looking at is the Unlcvt.bat file in the tools\maximo\internal directory.
This allows you to "export" your maximo data in a different database format. Basically it creates a file similar to the one they use for MAXDEMO but using your database. I believe you then use MAXINST pointing to the file that was created as the source file to use (instead of MAXDEMO).
There is potentially some "cleanup" you may have to do afterwards, but could be a real time saver.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Elberte Pongelupe
Sent: Tuesday, June 19, 2012 8:24 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Upgrade with change DBMS
Dear all,
Someone has migrated a Maximo database 7.1 of IBM DB2 to MS-SQL Server?
I have a customer who needs to upgrade from version 7.1 to version 7.5. But he also wants to change the database from DB2 to SQL Server.
I think the best way would be to migrate the database to SQL Server and after perform the upgrade. However, there are several settings in TPAE concerning the DBMS, such sequences, triggers, etc ...
Perhaps the best way would be to install a CORE product in version 7.5 and migrate data from IBM DB2 to SQL Server using the maximo integration framework (MIF).
Let me know what you think about ...
Thanks, Elberte.
Thanks Sean Clark. I'll test this option.
Regards, Elberte.
________________________________
De: Sean Clark-McCarthy <smccarthy@cohesivesolutions.com>
Para: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Enviadas: Quarta-feira, 20 de Junho de 2012 17:13
Assunto: RE: [MAXIMO List] Upgrade with change DBMS
One thing worth looking at is the Unlcvt.bat file in the tools\maximo\internal directory.
This allows you to "export" your maximo data in a different database format. Basically it creates a file similar to the one they use for MAXDEMO but using your database. I believe you then use MAXINST pointing to the file that was created as the source file to use (instead of MAXDEMO).
There is potentially some "cleanup" you may have to do afterwards, but could be a real time saver.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Elberte Pongelupe
Sent: Tuesday, June 19, 2012 8:24 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Upgrade with change DBMS
Dear all,
Someone has migrated a Maximo database 7.1 of IBM DB2 to MS-SQL Server?
I have a customer who needs to upgrade from version 7.1 to version 7.5. But he also wants to change the database from DB2 to SQL Server.
I think the best way would be to migrate the database to SQL Server and after perform the upgrade. However, there are several settings in TPAE concerning the DBMS, such sequences, triggers, etc ...
Perhaps the best way would be to install a CORE product in version 7.5 and migrate data from IBM DB2 to SQL Server using the maximo integration framework (MIF).
Let me know what you think about ...
Thanks, Elberte.
Thanks Dave,
Elberte.
________________________________
De: in2data <in2data@yahoo.com>
Para: MAXIMO@yahoogroups.com
Enviadas: Quarta-feira, 20 de Junho de 2012 13:02
Assunto: [MAXIMO List] Re: Upgrade with change DBMS
Hi,
Back before 4.1.1 we moved from SQL Base to SQL Server. At that time PSDI (later renamed MRO then purchased by IBM) sold conversion software. Maybe IBM has some software.
You could try what you suggested.
Dave Bone
--- In MAXIMO@yahoogroups.com, Elberte Pongelupe <epongelupe@...> wrote:
>
> Dear all,
>
> Someone has migrated a Maximo database 7.1 of IBM DB2 to MS-SQL Server?
>
> I have a customer who needs to upgrade from version 7.1 to version 7.5. But he also wants to change the database from DB2 to SQL Server.
>
> I think the best way would be to migrate the database to SQL Server and after perform the upgrade. However, there are several settings in TPAE concerning the DBMS, such sequences, triggers, etc ...
>
> Perhaps the best way would be to install a CORE product in version 7.5 and migrate data from IBM DB2 to SQL Server using the maximo integration framework (MIF).
>
> Let me know what you think about ...
>
> Thanks, Elberte.
>
>
>