SQL Server Migration Assistant for Oracle

preview_player
Показать описание
A demonstration of the SQL Server Migration Assistant for Oracle.
It also shows the stored procedure code, code for views and datatypes. So you can compare your Oracle Code and definitions with those that will be created in SQL Server.

Рекомендации по теме
Комментарии
Автор

Nice video. Thanks. One thing I'd be curious about is, what if you have a large schema with several errors that require manual modification at the destination? What's the process flow for that? Specifically, can you run the migration, then in the Migration Assistant, go to each problem object and manually fix it in the destination?

BenjaminGSlade
Автор

Thank you for proper explanation... I have 1 questions, can you guide on oracle sequence migration?

Mau_N_Mom
Автор

you did not rant "convert schema" .. may be because you manually created the object in sql server db ?

AKsharma_NL
Автор

I can do migration process by SSMA manually, but i need to do periodically ( as scheduled job ) any idea ?

MarphiLeu
Автор

Hi, Thanks for the video, its helping me with migration. I have a query what is Equivalent of Oracles sys_context ('USERENV', 'Client_Identifier') in SQL Server. I am getting errors w.r.t same after schema conversion..

abrahammathew
Автор

Hi, can you do a video showing some error with the Oracle number datatype conversion? By default SQL server will set as float[53]. How can we change to numeric? I try that in project settings. But the SSMA doesn't allow me to migrate successfully.

DesChew
Автор

Does Migration assistant can only be installed in SQL Server machine

Dorairaj-rw
Автор

Is there a way to schedule this SSMA process ?

-minuteshorts