Tag: Oracle Migration Planning

SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project. The new version of SSMA,…

SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project. The new version of SSMA -…

By James Cusick, Imran Riaz, Hubert Huang, Allen Tse, Murugan Gnanavel {james.cusick; imran.riaz; hubert.huang;allen.tse; murugan.gnanavel} @wolterskluwer.com Wolters Kluwer Corporate Legal Services, New York, NY Abstract A common problem in application development requires a port of existing and modified functionality to a new target technological platform. In this paper a recent experience is detailed on porting…

Microsoft announced the release of Microsoft Assessment and Planning (MAP) toolkit 6.0. The new version of MAP reports the existence of Oracle database instances and provides information that can be use to estimate total cost of ownership and return-on-investment (ROI) for migrating the Oracle schema to SQL Server. You can download MAP 6.0 from Microsoft…

SSMA automates conversion of most statement. There are a few features and syntax which SSMA is unable to migrate. In such situation, SSMA issues a migration error and for each error, SSMA provides estimated manual conversion time. I often asked how do we come up with the time. Those manual estimation time was calculated based…

By Bill Ramos and Vishal Soni, Advaiya Inc. This blog covers how the SQL Server Migration Assistant (SSMA) for Oracle uses the SQL Server Common Language Runtime (CLR) User-Defined Types (UDT) for emulating Oracle Records and Collections. In this blog, we will cover the following topics related to CLR UDTs: o Declaring Record or…

SSMA provides a project setting that allow you to customize how the conversion is done. This post describes the project setting options available for you as well as scenarios where you want to customize the setting. SSMA project setting options are categorized into the following: Project Information: provides project name and location where…