Unix Technical Forum

Data migration problems in sqldeveloper

This is a discussion on Data migration problems in sqldeveloper within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi, I am trying to migrate the database from SQL Server environment to Oracle 10g database. I am using ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 01:05 PM
Shishir
 
Posts: n/a
Default Data migration problems in sqldeveloper

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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 01:06 PM
RJ
 
Posts: n/a
Default Re: Data migration problems in sqldeveloper

I'm no master so don't quote me, but it seems that the T-SQL (from SQL
Server) probably cant be translated to PL/SQL (Oracle)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:03 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com