CODEWITHSUNDEEP
sql-serveroracle-databasemigration
Javier
Javier

Reputation:

Migrating from Oracle to Sql Server

I need to create a new db in SQL Server, and move some data from an Oracle db to this SQLServer db;

I read that this function can be implemented by using SSIS or the SQL Server Migration Assistant for Oracle;

I wonder if someone can point me to a tutorial or a document where I can see how this task is performed step by step

The data moved from the Oracle db is updated on a day basis, so the data moved has to be updated regularly.

Upvotes: 5

Views: 1172

Answers (2)

Booji Boy
Booji Boy

Reputation: 4582

How about this:

http://aspalliance.com/947_building_a_sql_server_2005_integration_services_package_using_visual_studio_2005

and this:

http://msdn.microsoft.com/en-us/library/ms169917.aspx

Upvotes: 0

Galwegian
Galwegian

Reputation: 42257

Have you looked at the SQL Server Migration Assistant for Oracle?

Step by step document on how to use it.

Upvotes: 3

Related Questions