Toad World® Forums

Moving Data from SQL Server DB to Oracle 10g DB

Hi folks … I have requirement to move data from a SQL Server Database to a new
schema in Oracle 10g Database.

Is this possible through Toad ?

Regards,

Shiva.

Hi Shiva,

Hi folks … I have requirement to move data from a SQL Server Database to a
new schema in Oracle 10g Database.
Is this possible through Toad ?

With Toad, everything is possible. :slight_smile:

While I wouldn’t necessarily use Toad for Oracle to do something like this,
included with newer versions (10.x and up, maybe?) is Toad for Data
Analysts. TDA allows one to connect to multiple disparate data sources
simultaneously and just might do what you’re looking for. If you’ve used
Toad for SQL Server, TDA has a very similar look-and-feel.

Some things that you’ll need to consider to do your project:

  1. Is this a one-time-shot or a repeating process?
  2. How much data is to be moved and over what type of network?
  3. What types of data are there to move (datatype conversion)?
  4. What are your timing constraints?

Depending on your answers, TDA might work very well for you. It may be more
beneficial to create a Linked Server in SQL Server to your Oracle DB. But
that’s something for you to decide. We can only supply you with options.

HTH! GL!

Rich – [TeamT]

Disclaimer: Are you ready for some football?

Oracle has a utility for you to do that too, it will create the tables and help
with data type translation

Rich is spot on, those 4 steps would make for an excellent white paper on the
subject!