SQL SERVER to Oracle Numeric Datatype Mapping

오라클을 모르니 ㅠ.ㅠ

마이그레이션 작업도 해봐야되고 참 그렇다.

   

   

   

This set me into this journey of educating the migration team on how important it is to send the appropriate data when working inside SQL Server. These might not be simple and I don't recollect writing about these. See below a pseudo mapping of datatypes that one needs to use when doing such migration exercise.

It is important to take the time to do profiling on the data in your source database to know what you are moving over. People often use data types that are too big and unnecessary for the application – this needs to be avoided. For example, if the application only uses 'Int' then use 'Int'. Again, this is an opportunity to improve the architecture and implementation as part of a migration.

   

출처: <http://blog.sqlauthority.com/2016/06/14/sql-server-oracle-numeric-datatype-mapping/>