import the data base from sql to oracle

• New persopn

  SSCarpal Tunnel

  Points: 4019

  More actions

  May 31, 2012 at 9:26 am

  #270024

  Hi All,

  I want to know how to import the data from sql to oracle

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 31, 2012 at 10:58 am

  #1495395

  You could use SSIS to transfer data from a SQL Server database to an Oracle database.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 1, 2012 at 1:05 pm

  #1496050

  The free Microsoft SQL Server Migration Assistant (SSMA) makes it easy to migrate data from Oracle, Microsoft Access, MySQL, and Sybase to SQL Server. SSMA converts the database objects to SQL Server database objects, loads those objects into SQL Server, migrates data to SQL Server, and then validates the migration of code and data.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato