TRIM upgrade with RDBMS change (Oracle 10g -> SQL 2008R2)
We are currently in the process of planning a migration from TRIM Upgrade 188.8.131.520 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 184.108.40.2060 -> 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 220.127.116.110 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.
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 DXC Technology.)
Analytics & Data Management Application & Business Services DXC Technology