SQL Server Migration Assistant (SSMA) Team's Blog
How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure
Translate This Page
Translate this page
Access Data Migration
Access Migration Assessment
Access Migration Error
Access Migration Planning
Access Schema Conversion
Migrate from Access
Migrate from MySQL
Migrate from Oracle
Migrate from Sybase
MySQL Data Migration
MySQL Error Messages
MySQL Migration Assessment
MySQL Migration Planning
MySQL Schema Conversion
Oracle Data Migration
Oracle Migration Assessment
Oracle Migration Error
Oracle Migration Planning
Oracle Schema Conversion
SQL Azure Migration
SQL Server "Denali"
SSMA Sybase ASA SQL Server Adaptive Server Anywhere
Sybase Data Migration
Sybase Migration Assessment
Sybase Migration Planning
Sybase Schema Conversion
Testing Database Migration
Browse by Tags
SQL Server Migration Assistant (SSMA) Team's Blog
migrate from sybase
Tagged Content List
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...
30 Jan 2012
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...
3 Aug 2011
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...
12 Jul 2011
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...
11 Jul 2011
"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 15 th 2012. Following are the products in SSMA v4.2 family of products for which this “End of Support” notice is applicable: SQL Server Migration...
11 Jul 2011
Setting multiple test case call values in SSMA
SSMA for Oracle and Sybase include tester suite to automate comparison testing between the source and target SQL Server database. The test cases can be defined using Test Case Wizard UI . You can specify database object to test (e.g. function), specify input argument value(s) for the function, SSMA will...
19 Jun 2011
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...
9 Jun 2011
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...
9 Jun 2011
How to: Migrate to a schema in an existing database using SSMA
SSMA, by default, migrate to dbo schema in a SQL Server database with the same name as source database schema you are migrating from. If the database does not exists, then SSMA will prompt if you like to create a new database. You can modify the target migration to an existing database with the following...
25 May 2011
How to migrate data fast from Sybase to SQL Server
[Updated: 2/8/2012 Selina Jia- the latest SSMA is v5.2, which has no Provider option in the project settings , so below cannot be applied to SSMA 5.2. But, if you don't want to use initial Provider to migrate data, you can change it in below dialog which will pop up when you migrate data: ]...
19 May 2011
Video: Introduction to SSMA
This video introduces SSMA tool including how to download and install as well as provide quick tour of SSMA user interface: Format: wmv Duration: 03:21 Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA...
5 Feb 2011
Accelerate migration to SQL Server with MAP Toolkit 5.5
Welly S Lee
The next version of the Microsoft Assessment and Planning (MAP) Toolkit—version 5.5— is now available for free download. · Download MAP 5.5 Simplify planning for migration to the latest Microsoft products and technologies with the Microsoft Assessment and Planning (MAP) Toolkit...
16 Jan 2011
"End of Support" for Older SSMA v4.0 family of Products
[ Updated: 2/8/2012 Selina Jia] Microsoft would like to inform customers that support for SSMA v4.0 family of products (including SSMA Extension Packs) is going to end on October 30 th 2011. Following are the products in SSMA v4.0 family for which this “End of Support” notice is applicable...
19 Oct 2010
How To Perform Incremental Data Migration Using SSMA
SSMA provides an ability for you to customize sql statement used during data migration. This feature can be used in the following scenarios: Split migration of a large table into multiple iterations Migrate data partially based on specific criteria (e.g. migrate data only for a selected department...
4 Oct 2010
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...
21 Sep 2010
Installing SSMA Extension Pack on SQL Server Cluster
SSMA tool includes Extension Pack which installs sysdb database on the target SQL server environment to emulate Oracle/Sybase functionalities. There is a known issue for installing SSMA extension pack when the target SQL Server is a clustered enviroment. We are planning to address this issue in the future...
17 Sep 2010
Microsoft announces SQL Server Migration Assistant for MySQL
Migrate from MySQL to SQL Azure or SQL Server with ease! Microsoft announced today the release of first version of SQL Server Migration Assistant (SSMA) for MySQL! Along with this release, Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access with the latest v4...
12 Aug 2010
Page 1 of 1 (17 items)
© 2013 Microsoft Corporation.
Privacy & Cookies