DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Exp to SQL2000

  1. 09-19-2003, 02:25 AM #1
    sri_dba
    sri_dba is offline Member
    Join Date
    Jun 2003
    Posts
    108

    Exp to SQL2000

    Hi DBA's

    I am in the situation to move some important tables from oracle8i to
    MS SQL2000 Server, is there anyway to export the tables from oracle to sql directly.

    Please help in this.
    Reply With Quote Reply With Quote
  2. 09-19-2003, 03:00 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can use Data Transfomration Service of MS SQL Sever. Or use the flat files to transfer data.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  3. 09-19-2003, 04:10 AM #3
    gschuah
    gschuah is offline Junior Member
    Join Date
    Oct 2001
    Posts
    52
    Hi Sanjay,
    What kind of flat file that you mentioned? How to generate to flat file?
    Thanks & regards,
    GS
    Reply With Quote Reply With Quote
  4. 09-19-2003, 04:41 AM #4
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    I meant getting the data into flat files like comma saperated, using SQL*Plus and then load them into MS SQL Sevrer.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width