Latest Update – Microsoft SQL Server Migration Assistant (SSMA) v6.0 is now available.

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,…

24

Microsoft SQL Server Migration Assistant (SSMA) v5.3 is now available.

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 -…

19

Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available

Automating Database Migration to SQL Server 2012 SQL Server Migration Assistant (SSMA) v5.2 is now available. 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…

65

Migrating from Sybase ASE to SQL Server – How to use SSMA for Sybase

[Updated 2/7/2012 Jiafei Yuan – Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2.  The information provided below is still valid for SSMA for Sybase v5.2.  Users should download the lastest SSMA for Sybase]   In this blog, I’m going to walk you through the process of converting a derivation of the Sybase pubs2 (referred to as pubs in…

11

Migrating Sybase ASE to SQL Server: Similarities and Differences to Help in Planning a Migration Project

[Updated 2/7/2012 Jiafei Yuan – Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2.  The information provided below is still valid for SSMA for Sybase v5.2.  Users should download the lastest SSMA for Sybase] This blog post explores the similarities and differences between Sybase Adaptive Server Enterprise (ASE) database applications and administration with Microsoft SQL Server to…

2

Saving Comments During Migration

During migration to SQL Server, you may find that the source database schema contains some comments to describe the schema. This can be as a comment within programming code (such as Oracle PL/SQL) in procedure, function, package, view or as a comment that is part of the table/ column schema. SQL Server Migration Assistant (SSMA)…

1

Video: Converting Schema to SQL Server

This video walks you through the schema conversion of SSMA, including an example on how to resolve issue during conversion   Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting Schema to SQL Server Migrating Data Using SSMA Automating Database Migration Using SSMA Console…

2

How To Convert Individual Statement Using SSMA

You can use SSMA to convert a statement (such as PL/SQL) into T-SQL statement using SSMA. This functionality can be used, for example, to convert embedded SQL statement inside an application that connects to the database. Use the following steps to convert individual statement: Open SSMA tool Create a New Project (or open an existing…

2