Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8J2KDF07198 for ; Thu, 18 Sep 2003 21:20:13 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8J2KC507193 for ; Thu, 18 Sep 2003 21:20:12 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8INPTe13280 for oracle-l@orafaq.net; Thu, 18 Sep 2003 16:25:29 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D06AA; Thu, 18 Sep 2003 16:24:43 -0800 Message-ID: Date: Thu, 18 Sep 2003 16:24:43 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: David.Schmoldt@gazettecommunications.com Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: David.Schmoldt@gazettecommunications.com Subject: RE: Move SQL Server Tables to Oracle Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C37E3C.0025F150" ------_=_NextPart_001_01C37E3C.0025F150 Content-Type: text/plain; charset="iso-8859-1" Look into Oracle's Migration Workbench utility. It's a free download from OTN. It can move tables, table data, indexes, constraints, etc. Also converts data types if needed. I've used it to move Acess databases to Oracle and it works pretty well. I believe they have a SQL Server module as well. Dave -----Original Message----- Sent: Thursday, September 18, 2003 3:00 AM To: Multiple recipients of list ORACLE-L Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G _____ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger ------_=_NextPart_001_01C37E3C.0025F150 Content-Type: text/html; charset="iso-8859-1"

Look into Oracle's Migration Workbench utility. It's a free download from OTN.

It can move tables, table data, indexes, constraints, etc. Also converts data types if needed.

I've used it to move Acess databases to Oracle and it works pretty well. I believe they have a SQL Server module as well.

Dave

-----Original Message-----
From: Gunnar Berglund [mailto:oracledbasweden@yahoo.co.uk]
Sent: Thursday, September 18, 2003 3:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Move SQL Server Tables to Oracle

Hi all,

I need to move some sql server tables to oracle.

Do you have some ideas how to do it. I have no idea ...

rgds

G

Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger

------_=_NextPart_001_01C37E3C.0025F150-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: David.Schmoldt@gazettecommunications.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).