Re: Data migration problems in sqldeveloper

On Jun 25, 7:31 am, Shishir <shishir..._at_gmail.com> wrote:
> 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 :
>
> 1) 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.

I would be using the Oracle Migration Workbench and the SQL Server plugin rather than attempting to use SQL Developer. Go to:

http://www.oracle.com

find the downloads page and obtain the Migration Workbench utility. Or, you could use ErWIN if you or your company has a license for it.

David Fitzjarrell Received on Mon Jun 25 2007 - 07:38:16 CDT