impact on MariaDB GUI and report design AFTER changing from Oracle

marrowyung
marrowyung used Ask the Experts™
on
hi,

right now planning the last stage of oracle to mariaDB migration and here are some BI related question, hope you all can give a hand.

On the change on the DB and data column type. (e.g. Oracle varchar2() to MariadB varchar()),  usually any impact on GUI and report design?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
nociSoftware Engineer
Distinguished Expert 2018

Commented:
In general no.... as the underlying types can hold the same value.
In practice code that expects a float number (from a database) and nog receives an integer might have trouble if the code has not been adjusted.
(Numeric values are not passed as strings from database to frontend and vice versa) The GUI needs to be recompiled with the right drivers and the right schema.

Defaults may differ so leaning on heavy use of defaults may cause some work.
Date / Time formats and layouts may have those most changes. Those might require rework on queries to get an equal result.

Best is to try and walk through all screens. Let a regular user of the software do that they will spot differences a lot quicker.
marrowyungSenior Technical architecture (Data)

Author

Commented:
"In general no.... as the underlying types can hold the same value."

did you try similar migration before ? this is a big operation.

"In practice code that expects a float number (from a database) and nog receives an integer might have trouble if the code has not been adjusted."

sorry, what is nog  ? and what code has to adjust ?

"The GUI needs to be recompiled with the right drivers and the right schema."

you mean AFTER migration schema changed and that's why we need to recompile the BI tools ?

"Defaults may differ so leaning on heavy use of defaults may cause some work."

agree! so we need to redefine the default ?

" Let a regular user of the software do that they will spot differences a lot quicker."

this means setup the same BI tools on top of both DB and see the diff ?

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