CODEWITHSUNDEEP
sqldatabaseoracle-databasesybasesqlplus
deepyaman
deepyaman

Reputation: 547

How can I copy from Oracle to Sybase using SQL*Plus?

I have an application that stores data in an Oracle database. I want to copy selected rows from a table in this database to a table in a Sybase database (archiving records). Can I do this directly (i.e. without storing and loading results from a file)?

I've mostly looked into SQL*Plus

I also understand the following: "However, INSERT is the only option supported when copying to Sybase. The SQL*Plus COPY command does not support copying to tables with lowercase table names." However, I haven't been able to do this in SQL*Plus. I'll keep trying, but if anyone has an example of how to do it here, I'd very much appreciate it.

If this is not possible, is Oracle Data Pump (http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html) my best alternative?

Thank you!

Sincerely,

Deepyaman

Upvotes: 2

Views: 1178

Answers (2)

Neerav
Neerav

Reputation: 1429

The robust way to do this is create a flat file(txt,csv) or an INSERT sql from your "COPY_FROM_DATABASE". And then load it into corresponding table. You might have to do a bit of formatting in this sql in order to run it on a different server. I personally like INSERT sql better.

Upvotes: 0

N West
N West

Reputation: 6819

Your best bet may be to use some form of ETL tool to handle this if the size of your data is reasonable, rather than getting into the details of setting up the gateways, etc, between systems.

There are many options - Talend Open Studio (free), Informatica, or Microsoft SSIS all should be able to handle this.

Upvotes: 0

Related Questions