Post reply

Urgent - sql server 2005 express to oracle data copy

  • October 11, 2009 at 12:45 am

    #385555

    Hi,

    I need to copy the data in sql server 2005 express to oracle.

    I was able to backup and restore from one server to another.

    I need a data copy from sql server 2005 express to oracle.

    I could not find DTS here.

    Can someone quickly help?

    Thanks

  • October 11, 2009 at 1:08 am

    #1064504

    update

    --> Using the generate scripts, I was able to generate a .sql file which can help me create all the db objects to use for oracle.

    Still, I did not have an option to dump the files data to a flat file.

    Help pls.

    Thanks

  • October 11, 2009 at 4:14 am

    #1064511

    First of all, DTS is a SQL Server 7 and 2000 tool.

    SQL Server 2005 has a much more advanced ETL tool called SSIS which would allow you to migrate data to an Oracle datasource.

    You can install the business intelligence development tools for express (not the full version). However, I have to admit, I have not used BIDS with Express, so I do not know if this will support your request.

    Another approach would be to extract the data from SQL Server using BCP and importing into Oracle using Oracle Bulk Loader.

Viewing 3 posts - 1 through 2 (of 2 total)

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