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

Thread: Importing a SQL 7.0 dB

  1. 06-21-2001, 10:07 AM #1
    Alex_D
    Alex_D is offline Junior Member
    Join Date
    Jun 2001
    Posts
    15

    Arrow

    What is the easiest way to import a complete SQL server 7.0 dB into a Oracle 8.0.5 environment?
    Reply With Quote Reply With Quote
  2. 06-21-2001, 10:42 AM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can use oracle taransparent gateway.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  3. 06-21-2001, 10:44 AM #3
    Alex_D
    Alex_D is offline Junior Member
    Join Date
    Jun 2001
    Posts
    15
    Is that apart of the Oracle 8.0.5 package? I have never heard of that before.
    Reply With Quote Reply With Quote
  4. 06-21-2001, 10:46 AM #4
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It is a serperate product, which you can download from
    http://technet.oracle.com

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  5. 06-21-2001, 11:30 AM #5
    Alex_D
    Alex_D is offline Junior Member
    Join Date
    Jun 2001
    Posts
    15

    Gateway

    I just looked it up. To purchase a tranparent gateway , you'd have to pay $15,000 USD. Come on, there must be a way to convert SQL to Oracle cheaper then that. What about importing the SQL into access and then from access to Oracle?
    Reply With Quote Reply With Quote
  6. 06-21-2001, 12:04 PM #6
    MJP
    MJP is offline Junior Member
    Join Date
    May 2000
    Posts
    50
    You could use SqlServer's DTS - Data Transformation Service to do that. I have done that several times successfully.
    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