Not really. You're changing database vendor, so the SQL is different (if you have manual queries - they need to be changed), tables, views, indexes are all different.
there is no way IDT or UDT can do this sort of switch automatically.
Fastest way is to create new Universe vs. chasing all the places where manual adjustment will be needed.
Hi Denis,
I found the way as below, After changing the connection from Oracle to SQL, right click on table and select Change Qualifier/Owner. Check mark Delimit
And then browse the Owner to select DBO
Perform the steps for all the tables in the universe and then refresh structure of universe. Save and validate all the objects and then publish the universe back to repository.
Add comment