Thursday, June 6, 2013

Hi,

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

Posted by at

2 comments:

  1. UnknownNovember 25, 2016 at 3:25 AM

    You can choose the best IT park in India to start or shift your business. While you choose office space on rent in Wardha visit us at www.wardhaitpark.com

    ReplyDelete
  2. AskvennelaFebruary 16, 2019 at 8:59 AM

    Thank you jamal, Your cooperation will get enthusiasm to write more articles in near future.

    ReplyDelete

Subscribe to: Post Comments (Atom)