Data Services heterogeneous copy

[AlbertVentosa]

Hi,

We're planning an heterogeneous copy from Data Integration 11.7 on Windows/Oracle to Data Services 4.2 on Windows/SQLServer. We've readed on Best Practices for upgrading older Data Integrator or Data Services repositories to Data Services 4....  that it's possible to create a copy of actual repository on to local repository and thus, connect this to a Data Services for doing the jobs upgrade. (Option 3)

Can we create this new local repository pointing to a SQL Server instance? Any experience about this kind of migration?

Many thanks!

[former_member185603 · Accepted solution]

Take a backup of local repos. Instead of creating new repos, upgrade the repos in place. That is quick.

Otherwise you need to create new repos, export the code via ATL, register them in CMS and Server manager. it is kind of double work.

If you see any issues while you doing the in place upgrade, you can always restore the old repos.

[AlbertVentosa · Accepted solution]

Hi Jawahar,

many thanks for your answer.

But the problem for doing this procedure is about database compatibility.

We've Oracle 9i as database repository, and it's shared with other applications.

As Oracle 9i isn't supported as RDBMS (minimun is 11g), we can't do the upgrade in place, and we can't do an Oracle upgrade to a supported release because it involves another applications.

And, because SQL Server is target RDBMS, we think it's mandatory create new repository at some step of this Project.

We think on:

1. Make backup of DI ( .atl file )

2. Create a local reposity against SQL Server.

3. Connect DI to new repository (SQL Server ) and import the atl backup

4. Testing new repository

5. Desconnecting new repository

6. Connect DS 4.2 to new repository and upgrade it.

What do you think?

Regards,

[former_member185603 · Accepted solution]

Yes, that is like good plan. I missed that you are moving from oracle to SQL server