This is the Trace Id: e557fd0088e289aad20a2c1eda30aa8c

Oracle Estate Assessment Tools for Migration to SQL Server

A set of scripts to to help with the collection of information for migration assessment across a large Oracle estate.

Important! Selecting a language below will dynamically change the complete page content to that language.

Download
  • Version:

    1.1.0

    Date Published:

    15/06/2024

    File Name:

    OracleAssessment.zip

    File Size:

    836.4 KB

    Collecting assessment information across a large data estate is a large manual effort. To optimize this process, we have created a set of scripts to collect both Pre-SSMA information (high level CSV information) and SSMA projects. Each set of scripts consist of a PowerShell script that is the main execution engine, an Excel spreadsheet that allows the customer to provide required details about each Oracle server and either SQL scripts (Pre-SSMA) or an xml script (for SSMAConsole) to do the actual commands to collect the required information/SSMA project.
  • Supported Operating Systems

    Windows 10, Windows 11, Windows Server 2016, Windows Server 2019

    The file is a zipped folder that contains the scripts. To run the SSMA collection script, you will need to install the latest SSMA for Oracle.
  • Choose the Download button on this page to start the download. Unzip the folder on a Windows machine and customize the PowerShell (.ps1) scripts as required for your local environment. Enter your server information in the Excel spreadsheet and run the utility.