SSMA Feature Overview

TechNet Magize published an article which provide overview of SQL Server Migration Assistant (SSMA) features and how it can be used to support database migration to SQL Server. SQL Server: Manage the Migration describes the main feature area of SSMA including migration assessment, converting database schema, migrating data, and testing database migration. If you prefer…

6

Applying Operational Profiles to Demonstrate Production Readiness Of an Oracle to SQL Server Database Port using Web Services

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…

5

Identifying Database Migration Opportunity Using MAP 6.0

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…

0

Announcing SQL Server Migration Assistant (SSMA) v.5.1

Automating database migration from Oracle, Sybase, MySQL, and Access database to SQL Azure and SQL Server “Denali”. Microsoft announced today the release of SQL Server Migration Assistant (SSMA) v.5.1, a family of products to automate database migration to all edition of SQL Server (including SQL Server Express) and SQL Azure. What’s New in this Release?…

15

Converting Oracle Sequence to SQL Server "Denali"

Updated 2/7/2012 Jiafei Yuan – Microsoft SQL Server Migration Assistant (SSMA) for Oracle v5.2.  The information provided below is still valid for SSMA for Oracle v5.2, but SQL Server “Denali” is changed to 2012.  Users should download the lastest SSMA for Oracle] One of the new feature in SQL Server Migration Assistant (SSMA) for Oracle v5.1 is…

1

Converting MySQL LIMIT to SQL Server "Denali"

[Updated 2/6/2012 Selina Jia – Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2.  The information provided below is still valid for SSMA for MySQL v5.2, but SQL Server “Denali” is changed to 2012.  Users should download the lastest SSMA for MySQL] One of the new feature in SSMA for MySQL v.5.1 is the support for converting…

0

How SSMA Estimates Manual Conversion Time

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…

0

"End of Support" announcement for SQL Server Migration Assistant v4.2 family of products (support ends on July 15th, 2012)

Microsoft would like to inform customers that support for SSMA v4.2 family of products (including SSMA Extension Packs) is going to end on July 15th 2012. Following are the products in SSMA v4.2 family of products for which this “End of Support” notice is applicable: SQL Server Migration Assistant 2005 for Access v4.2 SQL Server…

0

Migrating Oracle to SQL Server using SSMA – Error O2SS0351 Conversion of collection method not supported

By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t support the conversion of some of the collection method A collection is an ordered group of elements, all of the same type. It is a general concept that encompasses lists, arrays, and other familiar…

0

Migrating Oracle to SQL Server using SSMA – Error O2SS0350 Conversion of packaged variable (constant) data type is not supported in this release

By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the PL/SQL block when package variable holds an unsupported datatype such as INTERVAL datatype. In Oracle INTERVAL datatype defines a period of time that specifies the difference in terms of years and months,…

0