connection Oracle OLAP , Oracle application server, Oracle BI answer and BI server to MS SQL

marrowyung
marrowyung used Ask the Experts™
on
hi,

is it possible to connection Oracle OLAP , Oracle application server, Oracle BI answer and BI server to MS SQL ?

we are thinking about what if we just migrate Oracle DB to MS SQL DB and left the rest untouched.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Nope, there are few differences in terms of Oracle and SQL Server Architectures..
So, I don't think Oracle DB can be simply replaced or upgraded to SQL Server. You might need to work out on converting the logics and ensure they are working fine in SQL Server.
marrowyungSenior Technical architecture (Data)

Author

Commented:
"So, I don't think Oracle DB can be simply replaced or upgraded to SQL Server."

no. I mean if logic is all in application tier, can we just change connection to SQL server?

assuming all data and schema already replicated to the SQL server.
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Yes, you can try provided all the datatype conversions at the table level and all the packages in DB level are taken care..
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

marrowyungSenior Technical architecture (Data)

Author

Commented:
I also mean all oracle DB level business logic are move to the application level, then just change connection string, right?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Yes, it might but we need to test it completely..
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Hi marrowyung,
Kindly request you to let me know for more details on this question or else request you to close it accordingly..
marrowyungSenior Technical architecture (Data)

Author

Commented:
ttks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial