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.

Select language

Version:
1.1.0
Date Published:
6/15/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.