Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 To all Sql Server Gurus

Author  Topic 

jrdatla
Yak Posting Veteran

51 Posts

Posted - 2001-02-09 : 20:05:48
Hi Sql Server Gurus,

I want to know the procedure of converting the Sql Server 7.0 database to Oracle 8.0 Database.

I know that the Stored Procedures has to be written again in Pl/Sql but how about the data conversion to Oracle Database.

I have the following question.

1) How do we export the data from the Sql Server database to a Delimited text file so that i can use a Sqlldr to import into Oracle Database.

2) what about the Unique identifier in Sql Server as there is no such data type in Oracle.

Suggesstions welcomed

Jr. Datla
   

- Advertisement -