Re: Data migration problems in sqldeveloper

Shishir 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 have yet to see any software that does a good job of converting a T-SQL stored procedure to Oracle's PL/SQL. You'll probably have to do quite a bit of manual work here. Which means you'll need to understand both T-SQL and PL/SQL.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com