Maximo List Archive

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.



How to compare two Maximo environments to see if they are configured the same wa

From: TheoP (2011-10-12 13:39)

I'm curious - has anyone on this list created any tools or scripts that help compare the configurations between two Maximo environments (e.g., test and production) to confirm that they are the same? I know it's a daunting (and maybe impossible) task, but if anyone has anything that compares any number of objects (workflows, escalations, application designs, dbconfigs, etc.), I would be very interested.
Theo Pozzy
Portland General Electric


From: Chris Lawless (2011-10-12 07:56)

Theo - I have some scripts, I'll contact you directly to discuss their use
and usefulness in comparing environments.
Chris Lawless
Accenture
On Wed, Oct 12, 2011 at 6:39 AM, TheoP <tpozzy@yahoo.com> wrote:
> **
>
>
> I'm curious - has anyone on this list created any tools or scripts that
> help compare the configurations between two Maximo environments (e.g., test
> and production) to confirm that they are the same? I know it's a daunting
> (and maybe impossible) task, but if anyone has anything that compares any
> number of objects (workflows, escalations, application designs, dbconfigs,
> etc.), I would be very interested.
>
> Theo Pozzy
> Portland General Electric
>
>
>


From: fawad ullah (2011-10-12 08:14)


Guys,
 
May I also ask to have those scripts?  As i am also in the need to compare two of my Maixmo environments.
 
Thanks,
Fawad
 
--- On Wed, 10/12/11, Chris Lawless <lawlessc@gmail.com> wrote:
From: Chris Lawless <lawlessc@gmail.com>
Subject: Re: [MAXIMO List] How to compare two Maximo environments to see if they are configured the same wa
To: MAXIMO@yahoogroups.com
Received: Wednesday, October 12, 2011, 10:56 AM
Theo - I have some scripts, I'll contact you directly to discuss their use
and usefulness in comparing environments.
Chris Lawless
Accenture
On Wed, Oct 12, 2011 at 6:39 AM, TheoP <tpozzy@yahoo.com> wrote:
> **
>
>
> I'm curious - has anyone on this list created any tools or scripts that
> help compare the configurations between two Maximo environments (e.g., test
> and production) to confirm that they are the same? I know it's a daunting
> (and maybe impossible) task, but if anyone has anything that compares any
> number of objects (workflows, escalations, application designs, dbconfigs,
> etc.), I would be very interested.
>
> Theo Pozzy
> Portland General Electric
>
>
>
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join   : MAXIMO-subscribe@yahoogroups.com
Leave  : MAXIMO-unsubscribe@yahoogroups.com
Cry    : MAXIMO-owner@yahoogroups.com
Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links


From: Shannon Rotz (2011-10-12 11:01)

There's a product called DBDiff that works quite well for me. It compares
objects at the database level, i.e. required fields, table columns, etc.,
but can also compare data between tables if I remember correctly (I haven't
had occasion to use it for a while).

If you want to try it, it's here:

http://www.dkgas.com/dbdiffsq.htm


Note: this includes both DBDiff for SQL Server and DBDiff for Oracle. The
site also has the individual database versions available too.



Shannon

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
TheoP
Sent: October-12-11 6:39 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] How to compare two Maximo environments to see if they
are configured the same wa


I'm curious - has anyone on this list created any tools or scripts that help
compare the configurations between two Maximo environments (e.g., test and
production) to confirm that they are the same? I know it's a daunting (and
maybe impossible) task, but if anyone has anything that compares any number
of objects (workflows, escalations, application designs, dbconfigs, etc.), I
would be very interested.
Theo Pozzy
Portland General Electric


From: David Wadsworth (2011-10-12 15:47)

You can also feel free to download a free trial version of the Configuration
Pro "Analysis Edition" for Maximo. It's time limited but will do a full
compare for you so may help you troubleshoot the problem you're having. It
does a compare of the Maximo data model plus most other types of Maximo
configuration settings (workflow, mea/mif jobs, escalations, org/site
settings, etc). It saves the configuration data in a local file and then
walks you through comparing this to a different Maximo database or to the
same Maximo database at a different point in time to track changes, such as
before and after an upgrade. Also includes a few integrity checkers (in
the Tools menu) that makes sure Maximo indexes are in place, sequence
counters are high enough, etc.

This page will send you an email with a download link for ConfigPro:
http://www.assetpartners.com/configpro_request.html

David


From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Shannon Rotz
Sent: Wednesday, October 12, 2011 1:02 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] How to compare two Maximo environments to see if
they are configured the same wa


There's a product called DBDiff that works quite well for me. It compares
objects at the database level, i.e. required fields, table columns, etc.,
but can also compare data between tables if I remember correctly (I haven't
had occasion to use it for a while).
If you want to try it, it's here:
http://www.dkgas.com/dbdiffsq.htm
Note: this includes both DBDiff for SQL Server and DBDiff for Oracle. The
site also has the individual database versions available too.
Shannon
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
Of
TheoP
Sent: October-12-11 6:39 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] How to compare two Maximo environments to see if they
are configured the same wa
I'm curious - has anyone on this list created any tools or scripts that help
compare the configurations between two Maximo environments (e.g., test and
production) to confirm that they are the same? I know it's a daunting (and
maybe impossible) task, but if anyone has anything that compares any number
of objects (workflows, escalations, application designs, dbconfigs, etc.), I
would be very interested.
Theo Pozzy
Portland General Electric