Support for Oracle SSMA Tool

Question

Support for Oracle SSMA Tool

Darekar, Amol 40

My Team is planning to use Oracle SSMA tool for migrating Oracle DB to SQL Server on Azure. We would like to know if Microsoft supports the tool and how we can engage you guys.

Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator

2025-05-07T18:45:13.74+00:00

Darekar, Amol,
if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator

2025-05-07T18:45:13.74+00:00

Darekar, Amol,
if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Prasad Chaganti 645 Microsoft External Staff Moderator

Hi Darekar, Amol,

It sounds like your team is gearing up to use the Oracle SQL Server Migration Assistant (SSMA) for migrating your Oracle databases to SQL Server on Azure.

Microsoft does support the SSMA tool, which facilitates this migration process smoothly.

Here’s a brief overview of how to engage with Microsoft regarding the SSMA:

SSMA Overview: The SQL Server Migration Assistant for Oracle can help you convert Oracle database objects directly into SQL Server or Azure SQL objects. It also allows you to migrate data from Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics. You can find detailed documentation on this tool.
Please refer the document: https://learn.microsoft.com/en-us/sql/ssma/oracle/sql-server-migration-assistant-for-oracle-oracletosql?view=sql-server-ver16

Getting Started: You’ll first want to install SSMA and then create a new project in the SSMA interface. This involves connecting to both your Oracle and SQL Server instances to start assessing and converting your database objects. More information can be found in the guide on exploring the SSMA interface.

Please refer the document: https://learn.microsoft.com/en-us/sql/ssma/oracle/getting-started-with-ssma-for-oracle-oracletosql?view=sql-server-ver16

I hope this information helps. Please do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Darekar, Amol 40 Reputation points

2025-05-07T18:15:05.3533333+00:00

Thank you! I would also like to know how do we engage Microsoft team for this migration?
Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator

2025-05-07T18:43:24.6733333+00:00
Hi Darekar, Amol,

Engagement Process with Microsoft for SSMA Migration

1.Start with the SSMA Tool

The SSMA for Oracle is a Microsoft-supported tool that helps assess, convert, and migrate Oracle schemas and data to Azure SQL. The process typically includes:

Creating a new SSMA project

Connecting to source (Oracle) and target (Azure SQL)

Mapping schemas

Assessing compatibility

Converting and loading schemas

Migrating data

Updating applications if needed

This workflow is outlined in the

https://microsoft.sharepoint.com/:p:/r/teams/MCAPSAcademy/_layouts/15/Doc.aspx?sourcedoc=%7B85EBCBA6-F8D8-4500-994D-4AB6CE61F399%7D&file=%5BFINAL%5D-WRK334%20-%20Tools%20for%20Migrating%20Oracle%20Databases%20to%20Azure.pptx&action=edit&mobileredirect=true&DefaultItemOpen=1

2.Engage via Your CSAM

If your organization has a Customer Success Account Manager (CSAM), they are your primary point of contact for engaging Microsoft services. You can:

Request onboarding sessions

Schedule workshops

Coordinate support for your migration project

This is emphasized in the https://microsoft.sharepoint.com/:p:/r/teams/HubSMEs/_layouts/15/Doc.aspx?sourcedoc=%7BD3361432-2456-42AB-9283-DAA2807D2B16%7D&file=Services%20Hub%20Migration%20to%20Engage%20Center%20-%20Comparison%20and%20Best%20Practices.pptx&action=edit&mobileredirect=true&DefaultItemOpen=1, which notes that customers should reach out to their CSAM to discover and enroll in services

3.Use Microsoft Q&A and Support Channels

4.Leverage the APEx Program (Optional)

For a more structured and strategic approach, Microsoft’s APEx program offers tools like the MAP Toolkit to assess readiness and plan migrations. This is detailed in the https://microsoft.sharepoint.com/:p:/r/teams/mmexp/_layouts/15/Doc.aspx?sourcedoc=%7BBF1151E4-CA1E-4E45-ABC6-90A3EA044D39%7D&file=SQL%20Server%20Competitive%20Migrations_Seller%20Guidance%20Oracle.pptx&action=edit&mobileredirect=true&DefaultItemOpen=1&share=IQHkURG_HspFTqvGkKPqBE05AUXVAGJ3Q_Yfvykm10kFYdo

I hope this information helps. Please do let us know if you have any further queries.
Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator

2025-05-08T19:03:18.6+00:00

Hi Darekar, Amol,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Support for Oracle SSMA Tool

0 additional answers

Your answer