Post reply

Oracle to SQL Server 2000 migration

  • November 27, 2002 at 5:11 am

    #105923

    Can anyone give me a list of available ways to migrate oracle 817 to sql server 2000

    Thanks

    Paul


    Thanks

    Paul

  • November 27, 2002 at 8:09 am

    #442550

    Ways I can think of off hand

    DTS

    Import/Export Wizard

    Create linked server and query over

    dump the data to comma seperate or tab delimited text file and bcp in

    build an app to read from Oracle row by row and insert to SQL

    Or if you can find use the replication type tool, for Oracle to push to SQL, I don't remember the name sorry.

    I am sure there are others

  • November 27, 2002 at 8:15 am

    #442555

    Thanks, gives me somewhere to start looking

    Regards

    paul

    quote:

    Ways I can think of off hand

    DTS

    Import/Export Wizard

    Create linked server and query over

    dump the data to comma seperate or tab delimited text file and bcp in

    build an app to read from Oracle row by row and insert to SQL

    Or if you can find use the replication type tool, for Oracle to push to SQL, I don't remember the name sorry.

    I am sure there are others

    Thanks

    Paul


    Thanks

    Paul

  • December 3, 2002 at 8:23 pm

    #442988

    From 1st hand: we took the create a linked server and query over approach. Oracle has a nice provider and the transfer was almost seamless. using alinked server, we ran the oracle data base through the sql server linked server in "compatibility" before the conversion. (more work in that one word than you would believe.)

  • December 4, 2002 at 4:52 am

    #443045

    quote:

    From 1st hand: we took the create a linked server and query over approach. Oracle has a nice provider and the transfer was almost seamless. using alinked server, we ran the oracle data base through the sql server linked server in "compatibility" before the conversion. (more work in that one word than you would believe.)

    I have done that in the past mysefl, but recently have found newer versions of Oracle driver add support for specific datatypes that SQL cannot translate thru a Linked server itself so it needs prehelp in an openquery. I decided to move those items affected to a DTS process. Also, the Oracle drivers are quite touchy and may fail thru a linked server with an unknown error, if you run it several times thou it will eventually tell the error. I do believe that 8.17 is fine thou as Linked Server just keep an eye out for issues sismialr to the above.

  • December 4, 2002 at 4:59 am

    #443046

    Thanks for all your help, after researching this subject I can only find details relevant to DTS for the transfer, can any body recommend any other carrier system that will rival DTS, I have got to give multiple senarios to my boss.

    Thanks again

    Paul

    Thanks

    Paul


    Thanks

    Paul

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply