본 게시물은 개인적인 의견으로 작성되었으니 절대적인 정보가 아닐 수 있습니다. 참고만 하시고 궁금한 사항이 있으시면 연락주세요.

티스토리 뷰

SQL Server - CATEGORY

SQL SERVER to Oracle Numeric Datatype Mapping

시퀄人 2016. 6. 17. 09:45

오라클을 모르니 .

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

   

   

   

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/>

   

   

댓글
댓글쓰기 폼
1 ··· 63 64 65 66 67 68 69 70 71 ··· 328