How about using SQL Server's DTS ? So long as you have Net8 plus an OLEDB
driver for Oracle installed on your SQL Server box you can just shift the
tables across. Point and click in true SQL Server fashion, you can't go
wrong.
Ade
-Original Message-
Sent: 04 February 2003 14:40
To: Multip
Another thought is to use DTS to handle at least some of the transfer for
you. SQL Server's DTS (Data Transformation Services) package will be able
to connect to Oracle, create the table structure and import the data for
you. You are on your own as far as foreign keys and primary keys, etc. But
Read-up:
http://otn.oracle.com/documentation/oracle9i.html
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 h
Babu - Congratulations on the project! Is this database especially large or
are you facing severe restrictions in terms of the amount of time the data
is unavailable to your users? Are there any unusual objects in SQL Server
that will be difficult to create in Oracle? I think Oracle provides a
migr
Look into Oracle Migration Workbench (on technet, it's free).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 04, 2003 4:18 AM
> Hi Listers,
>
> We are planning to migrate one of our