CODEWITHSUNDEEP
oracle-databasesql-server-2008migration
rovsen
rovsen

Reputation: 5022

migration from oracle to sql server 2008

Are there any tools that I can use to migrate my Oracle database to SQL Server 2008? If not what are other choices for this type of migration?

With migration I need to move only tables (with all indexes and constraints) and data. There are no any functions, views or stored procedures.

Upvotes: 2

Views: 2009

Answers (1)

marc_s
marc_s

Reputation: 755491

See e.g.

Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a free tool for migrating Oracle databases to Microsoft SQL Server. SSMA for Oracle converts Oracle database objects (including stored procedures) to SQL Server database objects, loads those objects into SQL Server, migrates data from Oracle to SQL Server, and then validates the migration of code and data.

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

or many more commercial offerings - Bing or Google are your friends!

Upvotes: 1

Related Questions