[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

SSMA for Oracle to SQL 2k5

I treid to googlefor the migration assistant to migrate from oracle to Sql 2005 but coudnt find any only found for 2008. Will 2008 SSMA work for 2005 too? Please help!
0
parpaa
Asked:
parpaa
1 Solution
 
ValentinoVBI ConsultantCommented:
Check this out: http://www.microsoft.com/Download/en/details.aspx?id=28766

This download includes a GUI client based application to manage migration process as well as SSMA extension pack to be installed on target SQL Server. SSMA extension pack includes functionalities to emulate Oracle features not natively supported in SQL server, tester database to support SSMA Testing features, and an application to facilitate direct server-to-server data migration.
SSMA for Oracle v5.2 is designed to support migration from Oracle 7.3 or later version to all edition of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

(quoted from link above)
0
 
Ryan McCauleyCommented:
SQL 2005 and 2008 are very close functionality-wise, and I'd expect any walk-through or tools that are designed for SQL 2005 to also work for newer versions. I'd say you're safe to use that tool to handle your migration to SQL 2008.
0
 
parpaaAuthor Commented:
Thanks it worked like a charm!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now