TRIM upgrade with RDBMS change (Oracle 10g -> SQL 2008R2) (505 Views)
Reply
Advisor
Phil_The
Posts: 31
Registered: ‎09-03-2012
Message 1 of 5 (505 Views)
Accepted Solution

TRIM upgrade with RDBMS change (Oracle 10g -> SQL 2008R2)

Good afternoon,

 

We are currently in the process of planning a migration from TRIM Upgrade 6.2.4.1240 on Oracle 10g to 7.x on SQL 2008 R2. Research to date (and some discussions with various vendors) suggest that the easiest way to undertake this upgrade is to change the RDBMS to SQL 2008 R2 with the current version of TRIM and then follow that up with a straight TRIM 6.2.4.1240 -> TRIM 7.x migration.

 

My understanding is that the TES migration option under tools should be sufficient to migrate existing datasets from one RDBMS to a new platform; provided that the intial database can be confirmed as clean, and perhaps a schema repair on the destination server performed afterwards. Once this has been successfully accomplished, a TRIM 6.2.4.1240 upgrade to 7.x using the fresh SQL database should (I assume) be relatively straightforward.

 

I'd appreciate any thoughts on the above strategy, whether this is the "preferred" methodology to perform a combined TRIM/RDBMS ugprade and/or suggestions on better alternatives.

 

Please note that the above is just a summary of what is being considered; I'm just interested in thoughts on the overall process. Whatever course of action is ultimately decided upon, I envisage several months of work in DEV and TEST to iron out the exact steps required to safely carry out this upgrade.

 

Thanks for your time,

 

Phil

Honored Contributor
Grundy
Posts: 2,845
Registered: ‎02-16-2009
Message 2 of 5 (472 Views)

Re: TRIM upgrade with RDBMS change (Oracle 10g -> SQL 2008R2)

Hi Phil, 

 

Your steps are correct, you can migrate using the TES to move from Oracle > SQL.

You can do this either in 6.2.4 or 7.X.

 

Another customer I have just been working with went from 6.1.3 Oracle 10G to 7.1.2 SQL 2008 a few weeks ago.

They have managed to get there successfully and didn't require too much prior testing/planning to do this.

(They were going to go to 7.1 with Oracle 10G, but it's not supported, so the decision to go to SQL Server was only made fortnight before the upgrade!)

 

As I advised these guys, run some migration testing now so you understand the process and you can then check to see if your data migrates cleanly and if any errors come up.

 

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Honored Contributor
Sander Hoogwerf
Posts: 377
Registered: ‎11-05-2008
Message 3 of 5 (467 Views)

Re: TRIM upgrade with RDBMS change (Oracle 10g -> SQL 2008R2)

Migrating through TES takes quite a while if you have a large database.

For a ~50GB Oracle database I've once experimented migrating through the SQL Server Data Transformation Services (now replaced by Integration Services) and TES in parallel. By the time DTS was finished (it took just a few hours), TES hadn't even finished exporting TSACCESSCO which was already taking ~20GB of XML files. So if testing shows you cannot finnish in a weekend using TES due to time constraints, then using the database tools is also an option.

But as always, you should test the procedure thouroughly.

(Any opinions expressed in this forum are my own personal opinion and should not be construed as an official statement by Hewlett Packard.)

Analytics & Data Management
Application & Business Services
HP Enterprise Services
Advisor
Phil_The
Posts: 31
Registered: ‎09-03-2012
Message 4 of 5 (425 Views)

Re: TRIM upgrade with RDBMS change (Oracle 10g -> SQL 2008R2)

Our TRIM database size is roughly 20Gb. As part of a trial test of the data migration process we:

 

1. Used a 3rd party data migration tool to transfer the oracle data to SQL (excluding all the temp tables etc.)

2. Did a schema repair.

 

End result was most satisfactory and took about 17 hours to complete on Test hardware.

 

Note: We did shy away from both TES and SSIS as some individuals advised that both can be time consuming (and in SSIS case, overly complex).

 

Thanks for all your feedback; it is greatly appreciated.

Honored Contributor
EWillsey
Posts: 1,870
Registered: ‎04-20-2010
Message 5 of 5 (421 Views)

Re: TRIM upgrade with RDBMS change (Oracle 10g -> SQL 2008R2)

Can I ask which third-party tool you used?
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.