What kind of potential pro开发者_Go百科blems can be raised during migration from MySQL database to Oracle database?
I'm neither a MySQL nor a RoR expert, but I'll give it a go:
- maximum text column length (Oracle supports only 4000 chars, for longer ones you have to use CLOBs)
- Oracle treats '' (empty strings) as NULL
- Oracle object names have a maximum length of 30 chars (tables, views, columns, ...)
Have a look at
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
for further differences.
精彩评论