Recently we have started to migrate sql server database to oracle database.
Here's the issued we observed while migration.
Tool : Oracle Sql Developer -3.2.20.09.87
·
Default constraints are created with “NOT NULL“ but with '' (empty space)
·
Default constraints are created with “NOT NULL” but 'X ' (some x with empty space)
· Some of the predefined functions are used in sql server
eg. sp_executesql
stuff,
convert,
cast
· Sql queried used in dynamic rows count fetching..
