In near future we are planning to move both CMS and CDS databases from Oracle to SQL server.
As a first step we want to migrate Content Data Store (Broker DB) from Oracle to SQL Server.
CMS database migration will take long time as we have 100+ publications and we will have to use content porter. So we expect some delay there.
In this case our CMS will be using Oracle database but CDS will be using SQL Server database.
Can anyone point us to Pros and Cons of this hybrid approach. Is this supported option, and will it work in long term?