Good morning Stephen,
how did you come to the idea that I may be among the first persons to respond to your question? Strange...
It is not at all advisable to work with database backups when it comes to migrating Informatica environments; you should always use the backup functionalities provided by Informatica, DB backups can cause all kinds of trouble.
From this perspective you should indeed not even use Oracle in the new infrastructure but start with SQL Server right away (no matter whether on Azure or "locally" or whatever, as long as the intended SQL Server version is supported by the Informatica software and this infrastructure is supported by Informatica for repositories).
Then you can restore the Informatica backups in the new infrastructure and perform the actual upgrade.
Second yes, they do have a (as of now potential) problem. If they do not pay for extended support, then they have to HOPE that everything goes smoothly beyond the validity of their license.
Now I have never been a GCS engineer and am not too familiar with the shipping and licensing processes, so I can only guess. As of my (limited!) understanding you will get support for the 9.6.1 installation only as long as the 9.6.1 license contract is valid, not a single day longer. And in fact it may even be that your customer can get an extended license for the migration but that there will be no extended support available for this extension time; I really can't tell for sure, they (not you) should contact the Informatica sales representative for this government organisation and try to find a way how to proceed.
Please note that I do not think that they will succeed in this undertaking; I fear the sales representative cannot extend the license beyond the end of extended support, not even for a single day. So they will have to make sure at all costs that they have migrated everything before this date, otherwise they will lose metadata (possibly ALL metadata for their PowerCenter processes). Informatica does not care too much about internal government processes, they expect their customers to take care of such upgrades on time; after all Informatica informs their customers early enough about the time lines so that all customers can plan accordingly.
Again, this is a matter of negotiation and good will. Good luck with that, I don't envy you for this situation.
Good Afternoon Nico,
I meant to follow up with another question.
Oracle vs Microsoft SQL Server.
I’m reading that you can’t migrate to Microsoft SQL Server within Informatica if you are not on a Windows machine.
We are going to be using RedHat.
Any chance you could confirm for me?
Have a great weekend!
Stephen St. Germain
PS Sr Consultant
Teradata - Data Integration Practice
Skype ID Stephen.St.Germain
Cell Phone – (315) 243-7114
That depends on the version. Until 9.6.x, you can NOT have PowerCenter repositories on SQL Server if PowerCenter doesn't run on a Windows machine. Since 10.0 this is no longer true.