April 11, 2008 at 4:06 am
[font="Verdana"]Hi All,
I have Oracle9i and SQL Server 2000 installed on my machine. Before two years I used to work on Oracle. However in recent 2 years I migrated to SQL Server. OK, that is not an issue.
I had no precious data on SQL Server, but on Oracle, except temporary tables created on it SQL Server. So last night what I did, I tried to import the whole data from Oracle to SQL Server. Except tables nothing got imported into SQL Server. I couldn't import Views, Functions as it is from Oracle. While importing Views they get imported but as tables into SQL Server. Means when I tried to look view under the View object, after I got the message of successful importing of objects, I didn’t find anything there. So I checked the Table objects and there I find the view. It is something like when importing Views they first got executed and the result-set got saved in SQL Server in the form of table. Is it so?
So basically my question remains here is, how can I import View, Function, Store Procedure into SQL Server from Oracle?
Hopes I have explained well. Please do let me know, where I went wrong?
Thanks in advance,
Mahesh
[/font]
MH-09-AM-8694
April 11, 2008 at 6:54 am
Importing views, stored procedures, functions isn't straigth forward because different SQL-dialects (TSQL vs PL/SQL ...). Have you tried copy objects?
The following link is the microsoft guide on how to migrate oracle to sql server
2000: http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx?mfr=true
2005: http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply