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

[@LauraShulldoTERRA]

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

[@C_G_1962]

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.

[@alexciortea2141]

Happy to hear that Claudio!

[@MarphiLeu]

Any idea to how to schedule as job periodically to migrate ?

[@aravindrajendran5086]

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

[@phalachandradevarakonda5626]

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

[@ajathaindira]

Waiting for next episode please

[@alexciortea2141]

Thank you Ajatha! Coming soon:)

[@FantasyLapse]

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

[@innocentobie5327]

Awesome 😎

[@alexciortea2141]

Thank you!

[@radosawmiszczyk3134]

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

[@aravindrajendran5086]

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

[@desmondong5481]

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

[@akshatapatil9732]

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

[@cristinacalin4199]

SSMA can be used to migrate from Oracle, DB2, Sybase, MySQL and Access to SQL/Azure SQL. If you are looking to migrate from AWS Redshift to Synapse Analytics you could leverage ADF: Copy data from Amazon Redshift using Azure Data Factory or Synapse Analytics docs.microsoft.com/en-us/azure/data-factory/connector-amazon-redshift?tabs=data-factory

[@Mmusic5557]

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

[@guigoerl]

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

[@mc30mp42]

Can SSMA handle delta migration?

[@mozartiano123]

I don't think so. I worked with it and whenever we needed to load the data it just refreshed everything. For that you would need to use ADF or stored procedure in the data part.