# Migrating Data From Sybase To Oracle

**URL:** <https://forums.toadworld.com/t/migrating-data-from-sybase-to-oracle/6405>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [December 2, 2010, 4:13pm UTC](https://forums.toadworld.com/t/migrating-data-from-sybase-to-oracle/6405 "2010-12-02T16:13:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Toad100](https://avatars.discourse-cdn.com/v4/letter/t/b9e5f3/32.png) [@Toad100](https://forums.toadworld.com/u/Toad100)\
**Post date:** [December 2, 2010, 4:13pm UTC](https://forums.toadworld.com/t/migrating-data-from-sybase-to-oracle/6405/1 "2010-12-02T16:13:10Z")

</div>

I am able to create database connection with Sybase and a separate database with Oracle. It appears TOAD for Data Analyst allows export of Sybase table to file, then import of file into Oracle table. But what I want to do is to export data from Sybase table to directly into Oracle table, using TOAD Data Analyst. Please advise.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [December 2, 2010, 5:03pm UTC](https://forums.toadworld.com/t/migrating-data-from-sybase-to-oracle/6405/2 "2010-12-02T17:03:45Z")

</div>

You can do this in TDA version 2.7. Use the Import Wizard Add Query type. Here you can point to the Sybase table and import into Oracle.

See the video in this link. How to do this is about 9 minutes into the video.

[http://tda.inside.quest.com/entry.jspa?externalID=4364&categoryID=291](http://tda.inside.quest.com/entry.jspa?externalID=4364&categoryID=291)

Debbie