Oracle to SQL migration - beyond SQL Server Migration Assistant (SSMA)
Oracle to SQL migration is complex. Real-world challenges are just too many to be solved by SSMA. In this session, learn about the teething issues and practical techniques to overcome them. Learn how to leverage SSMA and solve a few problems manually without using SSMA. The session includes a special focus on programmable objects like procedures and user defined functions. See practical examples of fixing Oracle code that fails in SQL Server post migration. Also, learn how to deal with data types incompatibility between Oracle and SQL Server. Towards the end of the session we show how tSQLt unit testing framework can be used for functional testing of migrated objects.