CODEWITHSUNDEEP
sql-serverssisdata-migration
user133580
user133580

Reputation: 1509

Can I use SSIS to move all tables from an SQL Server database to an Oracle schema?

I want to move all tables from an SQL Server database to an Oracle schema using SSIS. Is this possible?

Upvotes: 0

Views: 2796

Answers (1)

G.S
G.S

Reputation: 777

I guess , You are still following the post.

  1. Open BIDS.

  2. Project ->SSIS Import Export wizard.

  3. Data Source : SQL Server Native Client.

  4. Select Server Name and Source Database.

  5. Select Destination : Oracle Provider for OLEDB.

  6. Enter Destination database Credential.

  7. Click allow saving password.

  8. Select copy data from one or more tables or views.

  9. Mark Source checkbox which will selec tall the source columns.

  10. Next->Next->Finish.

  11. The package gets created in SSIS.

  12. Execute the package.

Upvotes: 1

Related Questions