As you start planning the migration of the schema objects, one immediate concern will be the data type mismatches between SQLServer and Oracle. Here are some helpful links in determining the correct translation of data types (I had to dig a bit to come up with all these)

Terminology Differences –and Some data type correspondences

Data Type Mapping for Oracle Publishers 

Character Types – Translation between Oracle and SQL Server

Number Types  – Translation between Oracle and SQL Server

Application (CLR) Types: Chances are you have an application running against Oracle – that also needs to run against SQLServer. Hence, you need to understand how the CLR Types map to SQL Server .

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.

 Twitter Linkedin