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

Thread: How to copy SQL Server database to Oracle9i?

  1. 07-24-2003, 10:50 AM #1
    ttsim
    ttsim is offline Junior Member
    Join Date
    Jul 2003
    Posts
    20

    How to copy SQL Server database to Oracle9i?

    I have a small database-PhotoId(63MB)in SQL Server 2000, and would like to copy it to Oracle9i for testing, and will move it over to Oracle9i in the near future.

    The software - Vision Database Systems is currently accessing the PhotoId database - a student photo id database, which all students' pictures (jpg) is stored in a folder outside the SQL Server. I was wondering how I could copy and store jpg format in the same table in Oracle9i.
    Please advise.
    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 07-24-2003, 11:07 AM #2
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    -- Check the Documentation for migration
    -- Use migration workbench to import stuff to oracle
    -- or since in this case you have image files(as called in mssql), you can reverse engineer the objects and store them as blobs in external files just like mssql, bfiles ...
    -- Try it all out
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    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