Re: How to Get From Sequent to Sun

From: Tom Donnelly <tdonnell_at_ncrsoph.Sophia.NCR.COM>
Date: 29 Oct 92 09:37:40 GMT
Message-ID: <4153_at_ncrsoph.Sophia.NCR.COM>

In article <lerujjINNepr_at_west.west.sun.com> kennyl_at_Sun.COM (Kenny Lopez - Silicon Valley EDA District Sales Rep) writes:
>I have been given the following challenge...
>
>A Sequent is running Oracle Financials MPL 8.4
>I would like to replace the Sequent with a Sun SPARCserver 690MP
>The Sun SPARCserver must run Oracle Financials MPL 9.3.6
>I've been told that I can only migrate data across same versions
>(MPL 8.4 to MPL 8.4 not MPL 8.4 to MPL 8.6)

 This is true

>Oracle Financials MPL 8.4 does not exist/never ported to Sun
>We do not know if there is an Oracle Financials MPL 8.5 for the Sun
>We do know that an Oracle Financials MPL 8.6 exists for Sun
>
>How do I get to the Sun from the Sequent?
>
>After speaking to countless people at Oracle, I have been told
>that I only have two options available to me
>
> 1. Upgrade the Sequent to MPL 9.3.6 and migrate the
> data to the Sun running MPL 9.3.6

        If you could afford it, this would be the better way.
>
> 2. Upgrade the Sequent from MPL 8.4 to MPL 8.6,
> migrate the data to the Sun running MPL 8.6,
> upgrade the Sun to MPL 9.3.6
>

        This will work too.

>Is this true?

	One method I used once was to export the database ( in this case
	it was MPL7.3, V6.0.27 on a Pyramid ) and loaded up the database on 
	the target  ( an AT&T StarServer ).  I cut a new database on the
	StarServer under V6.0.30 and imported the database from the Pyramid.
	I then ran the Financials upgrade steps for 7.3 to 8.3.  It seemed
	to work o.k.  The prefered method of upgrading databases is a full
	export and import.  Because the database  was loaded with 7.3 format
	Financials data, I just ran the upgrade setpes on the target machine.

	What you have to check is that the MPL9.3.6 software on your target
	machine can perform the upgrade steps.
	machine.  

>
>Option #1 has been ruled-out because to perform the upgrade on
>the Sequent, I must spend close to $100K on HW and SW upgrades
>to the Sequent box. This also forces me to take my production
>machine off-line for 3-5 days.
>
>Option #2, I have been told, may take 3-5 days on the Sequent
>just for ther MPL 8.4 to MPL 8.6 upgrade, and then another
>3-5 days for the upgrade on the Sun from MPL 8.6 to MPL 9.3.2.
>The integrity of the data from the Sequent to the Sun is NOT
>GUARANTEED.

	I don't see why the integrity of your data would not be guaranteed.
	Oracle has a section in the installation and implementation manuals
	on migrating Oracle Financials, with all the steps to perform for 
	moving from one machine to another or one database to another.  Export
	and Import are supposed to be the way of moving a databse between
	platforms.  I would check with Oracle again.

>
>I been told that to upgrade within versions (ie 8.X to 8.X)
>is a no brainer if the database engine is the same. I've also
>been told the opposite...
>

	I have never found upgrading Oracle to be a no-brainer, but 'point'
	releasees are typically much eaier than majore release upgrades.  I
	would call the hotline to get as much information as to problems and
	workarounds before I started.

>Am I hosed?

No. But plan on a few hectic days and some late nights.

>
>Any suggestions?

---

These views are my own and do not represent those of my company. No guarantee, implied or other, unless specified by law. Details on back.

---

Tom Donnelly               | WIN: Tom.Donnelly_at_Sophia
NCR Europe Group ISS       | UUCP: ..ncrcom!ncrsoph!tdonnell
Sophia Antipolis, Valbonne |                              
France			   | TEL: 33-92 94 45 40

Received on Thu Oct 29 1992 - 10:37:40 CET