Post reply

Urgent - sql server 2005 express to oracle data copy

  • October 11, 2009 at 12:45 am

    #156300

    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 10:46 am

    #1064544

    to do this FROM SQLExpress, the table you are going to import into must already exist.

    in that case, you can add a linked server on the SQL Express to Oracle, and run an insert statement:

    insert into MyOracle..Tablename(ColumnList)

    select ColumnList from MySQLTable

    you can also do it from Oracle, by adding a DB Link...then you can create teh table in the oracle environment if it did not exist, and then do a similar insert statemtn select from the db link.

    does that help?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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