Migrating to SQL: Introduction to SSMA (Ep. 3) | Data Exposed

preview_player
Показать описание
Looking to leave Oracle behind? Watch the episode of Data Exposed with Alexandra Ciortea to find out how to ease into the migration journey by automating Oracle migrations to SQL Server or Azure SQL using SQL Server Migration Assistant. Customers looking to migrate from other database systems to Azure experience challenges in schema conversion, data movement. Microsoft SQL Server Migration Assistant (SSMA) is a suite of 5 tools designed to automate heterogeneous database migration to Azure SQL and SQL on-premises from Oracle, DB2, MySQL, Microsoft Access, and SAP ASE.

0:00​ Introduction
1:01​ Challenges
2:16​ SQL Server Migration Assistant Demo
14:40 Converting Statements Demo

🎞️ More episodes in the Migrating to SQL series:

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL​ #SQLServer​ #MigrationtoSQL​ #MigrationJourney​ #SQLServerMigrationAssistant
  1. Microsoft Developer
  2. Microsoft
  3. Developer
  4. Azure
  5. oracle migrations
  6. sql server
Комментарии
Автор

great information.. just started using ssma this week to convert oracle database to sql server.

LauraShulldoTERRA
Автор

Very good episode ! SSMA is a great tool ! I used it for (all on premises) migration from mysql to SQLserver. Using it to bring schema and data to Azure SQL is awesome.

C_G_
Автор

Need a video on the errors that occur while migrating data solutions

phalachandradevarakonda
Автор

hello, thanks for the great content. Please review the links for resource because they don't work anymore...

radosawmiszczyk
Автор

In Oracle and SQL table name is same but schemas is different, Is there possible to migrate data from oracle to sql?

aravindrajendran
Автор

How to migrate Clob data of oracle to sql server without any data break using SSMA

Mmusic
Автор

Can we migrate AWS redshift database to azure SQL sever using SSMA

akshatapatil
Автор

How do we change from source a numeric to destination as bigint?

desmondong
Автор

Hi can the SSMA be automated to run the data migration of schemas?

FantasyLapse
Автор

Hi, how to migrate data different schemas of tables in ssma, Is this is possible?

aravindrajendran
Автор

for simple data is perfect, when using Numbers and floats is a big shit

guigoerl