Servers

    Microsoft SQL Server Migration Assistant for Oracle v5.2

    Language:
    English
    Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database to SQL Server.
    • Version:

      5.2

      File Name:

      SSMA for Oracle 5.2.zip

      Date Published:

      1/29/2012

      File Size:

      8.6 MB

        SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Oracle to SQL Server. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.
        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.
    • Supported Operating System

      Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP

        Requirements for the SSMA for Oracle client:
        • Microsoft Windows Installer 3.1 or a later version.
        • The Microsoft .NET Framework version 2.0 or a later version. You can obtain it from the .NET Framework Developer Center.
        • Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
        • Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.
        • 1 GB RAM.

        Requirements for the SSMA for Oracle Extension Pack:
        • SQL Server 2005 or higher.
        • Microsoft Windows Installer 3.1 or a later version.
        • Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
      • After the download, you must extract the installation files before you can install SSMA for Oracle.

        Installing the SSMA for Oracle Client
        1. Double-click SSMA for Oracle.exe.
        2. On the 'Welcome' page, click Next.
        3. If you do not have the prerequisites installed, a message will appear that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
        4. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
        5. Read the 'Usage Report Settings' page, select or clear the feature reporting box, and then click Next.
        6. On the 'Choose Setup Type' page, click Typical.
        7. Click Install.
        In addition to the SSMA program files, you must also install the SSMA for Oracle Extension Pack on the SQL Server machine.

        Installing the SSMA for Oracle Extension Pack

        Note: SSMA for Oracle Extension Pack is not supported on Windows XP.
        1. Double-click SSMA for Oracle Extension Pack.exe file.
        2. On the 'Welcome' page, click Next.
        3. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
        4. On the 'Choose Setup Type' page, click Typical.
        5. On the 'Ready to Install' page, click Install.
        6. On the 'Completed the First Step of Installation' page, click Next. A new dialog box will appear, in which you select the instance of SQL Server for the extension pack installation.
        7. Select the instance of SQL Server where you will be migrating Oracle schemas, and then click Next. The default instance has the same name as the computer. Named instances will be followed by a backslash and the instance name.
        8. On the connection page, select the authentication method and then click Next.Windows Authentication will use your Windows credentials to try to log on to the instance of SQL Server. If you select SQL Server Authentication, you must enter a SQL Server login name and password.
        9. On the next page, select Install Utilities Database n, where n is the version number, and then click Next.The sysdb database is created and the user-defined functions and stored procedures are created in that database. If Install Tester Database option is checked the tester ssmatesterdb database will be created.
        10. To install the utilities to another instance of SQL Server, select Yes, and then click Next. Or, to exit the wizard, click No.
      • Licensing

        SSMA is a FREE download, and is available for use by any customer or partner with no charge or any obligations. However, the product requires a license key for activation. The key can be obtained after quick and simple registration. Microsoft reserves the right to use an e-mail address or phone number provided during registration in order to contact a customer regarding his/her SSMA experience. To help you with the registration process, a License Key Required dialog box opens the first time that you start the SSMA program.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

       Download a free trial of SQL Server 2014.
    SQL Server 2014
    Faster transactions, faster queries, and faster insights.
    Free trial