Data migration problems in sqldeveloper

From: Shishir <shishir456_at_gmail.com>
Date: Mon, 25 Jun 2007 05:30:41 -0700
Message-ID: <1182774641.032400.114280@j4g2000prf.googlegroups.com>

Hi,
I am trying to migrate the database from SQL Server environment to Oracle 10g database.
I am using SQL developer for the same.

On converting the captured model to oracle model , i am getting lots of migration errors and that is mostly in the stored procedures .

The general error is something like this : Stored Procedure 'usp_CONTMGTDWRCreateDWR' has language id of 'MSTSQL' so will not output for generation .

And when i copy the MS-SQl code in the scratch editor and press the translate button , i am predominantly getting these two errors :

cannot translate null 2)cannot translate > Unknown object : unxepected end of tree : Line 0 Column 0

Can anyone tell me what do these errors mean and how can i go about correcting them??

Thanks in advance.

Shishir. Received on Mon Jun 25 2007 - 07:30:41 CDT