The Curious Engineer

All blogs / Databases

SQL Server Migration Assistant (SSMA) Team's Blog

learn.microsoft.com/en-us/archive/blogs/ssma

How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
117 from 10 Aug 2010 to 21 Feb 2017
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/ssma/feed.xml

2017 1

  1. Released: SQL Server Migration Assistant (SSMA) v7.3

2016 4

  1. SSMA 7.1 Adds Support for migrating to SQL Server vNext CTP1
  2. SSMA 7.0 Adds Support for Migrating to SQL Server 2016
  3. Preview release of SQL Server Migration Assistant (SSMA) for SQL Server 2016 RC0
  4. Microsoft SQL Server Migration Assistant (SSMA) v6.0.1 is now available

2014 3

  1. Latest Update - Microsoft SQL Server Migration Assistant (SSMA) DB2 is now available.
  2. Latest Update - Microsoft SQL Server Migration Assistant (SSMA) v6.0 is now available.
  3. Microsoft SQL Server Migration Assistant (SSMA) v5.3 is now available.

2013 1

  1. Can’t migrate from Sybase ASA to SQL Server using SSMA

2012 3

  1. Procedures/Functions with ROWTYPE Parameters Defaulted to NULL
  2. Securing MS Linked Tables Connection Strings During Migration
  3. Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available

2011 89

  1. SSMA Feature Overview
  2. Announcing SQL Server Migration Assistant (SSMA) v.5.1
  3. Converting Oracle Sequence to SQL Server "Denali"
  4. Converting MySQL LIMIT to SQL Server "Denali"
  5. How SSMA Estimates Manual Conversion Time
  6. "End of Support" announcement for SQL Server Migration Assistant v4.2 family of products (support ends on July 15th, 2012)
  7. Migrating Oracle to SQL Server using SSMA - Error O2SS0351 Conversion of collection method not supported
  8. Migrating Oracle to SQL Server using SSMA - Error O2SS0350 Conversion of packaged variable (constant) data type is not supported in this release
  9. Migrating Oracle to SQL Server using SSMA - Error O2SS0339 Cannot Convert Standalone User-Defined Types
  10. Migrating Oracle to SQL Server using SSMA - Error O2SS0188 Sequence not found in source metadata
  11. Migrating Oracle to SQL Server using SSMA - Error O2SS0217 Call to identity sequence CURRVAL not supported
  12. Migrating Oracle to SQL Server using SSMA - Error O2SS0221 Call to identity sequence NEXTVAL not supported
  13. Emulating Records and Collections via CLR UDT
  14. Migrating Oracle ANYDATA to SQL Server
  15. Migrating Oracle to SQL Server using SSMA - Error O2SS0347 Comparison of record or collection expressions is not supported
  16. Migrating Oracle to SQL Server using SSMA - O2SS0264 Unable to convert cursor or cursor variable as a function or procedure call parameter
  17. Migrating Oracle Materialized View to SQL Server
  18. Migrating Oracle to SQL Server using SSMA - O2SS0359 Cannot get description for return type of function call expression
  19. Migrating Oracle to SQL Server using SSMA - Error O2SS0330/ O2SS0331: Unable to convert CLOSE/FETCH statement
  20. Migrating Oracle to SQL Server using SSMA - Error O2SS0157 Dynamic string for OPEN...FOR not converted
  21. Migrating Oracle to SQL Server using SSMA - Error O2SS0055 Incorrect EXCEPTION_INIT PRAGMA parameter
  22. Migrating Oracle to SQL Server using SSMA - Error O2SS0054 Unable to convert EXCEPTION_INIT
  23. Migrating Oracle to SQL Server using SSMA - Error O2SS0268 Hierarchical query with outer join cannot be converted
  24. Setting multiple test case call values in SSMA
  25. Migrating Oracle to SQL Server using SSMA - Error O2SS0260 Wrapped package cannot be converted
  26. Converting MySQL STR_TO_DATE function
  27. Migrating Oracle to SQL Server using SSMA - Error O2SS0038 Hierarchical query not converted
  28. Migrating Oracle to SQL Server using SSMA Error O2SS0007 Check constraint condition not parsed
  29. Migrating Oracle to SQL Server using SSMA - Error O2SS0274 Call to function with cursor return value cannot be converted in current context
  30. Migrating Oracle to SQL Server using SSMA - Error O2SS0418 Failed to parse statement batch with package definition
  31. Migrating Oracle to SQL Server using SSMA - Error O2SS0160 SELECT statement not converted
  32. Migrating Oracle to SQL Server using SSMA - Error O2SS0101 A parameter has been omitted, so there is no default value
  33. Migrating from Sybase ASE to SQL Server – How to use SSMA for Sybase
  34. Migrating Sybase ASE to SQL Server: Similarities and Differences to Help in Planning a Migration Project
  35. Migrating Oracle to SQL Server using SSMA - Error O2SS0343 FORALL statement with SAVE EXCEPTION clause is not supported
  36. Migrating Oracle to SQL Server using SSMA - Error O2SS0029 Cannot convert EXIT statement
  37. Migrating a PHP Application using MySQL to SQL Server running PHP on IIS
  38. Migrating Oracle to SQL Server using SSMA - Error O2SS0408 Collection or Record Type is not supported
  39. Migrating Oracle to SQL Server using SSMA - Error O2SS0104 Unpackaged function call is missing a parameter
  40. Access to SQL Server Migration: Understanding the Assessment Report and Error List
  41. Migrating Oracle to SQL Server using SSMA–Error O2SS0041 Illegal Identifier
  42. How to: Migrate to a schema in an existing database using SSMA
  43. Converting Oracle UDT to SQL Server TVP
  44. Improving Performance of SSMA Migration Assessment
  45. Migrating Oracle to SQL Server using SSMA - Error O2SS0407: Unsupported collection key type
  46. Migrating Oracle to SQL Server by using SSMA - Error O2SS0094 Unable to convert CURSOR as parameter
  47. Migrating Oracle to SQL Server using SSMA - Error O2SS0265 Unable to convert condition (with CURSOR attributes)
  48. Migrating Oracle to SQL Server using SSMA - Error O2SS0245: Cursor conversion in return statements not supported
  49. How to migrate data fast from Sybase to SQL Server
  50. Access to SQL Server Migration: Understanding SSMA Project Settings
  51. SSMA @TechEd Video
  52. SSMA 5.0 Extension Pack Installation Error
  53. Auto generate link table when migrating access database using SSMA
  54. Migrating Oracle to SQL Server using SSMA - Error O2SS0179 Packaged Variable (constant) data type not recognized
  55. Migrating Oracle to SQL Server Using SSMA - Emulating Oracle Package Variables
  56. Migrating Oracle to SQL Server using SSMA - Error O2SS0334 BULK COLLECT INTO Clause not converted
  57. Migrating Oracle to SQL Server using SSMA - Error O2SS0352 BULK COLLECT INTO clause in SELECT statement not converted
  58. Migrating Oracle to SQL Server using SSMA–Error O2SS0293: Columns list in set clause cannot be converted
  59. Converting from MySQL to SQL Server: Working with Data Types
  60. Migrating Oracle to SQL Server using SSMA - Error O2SS0205 Unable to convert PRAGMA AUTONOMUS_TRANSACTION
  61. SQL Server Migration Assistant v5.0 is now available
  62. Migrating Oracle to SQL Server using SSMA – Error O2SS0099 ROWNUM in ORDER BY clause is not supported
  63. Migrating Oracle to SQL Server using SSMA - Error O2SS0021 Statement with ROWNUM not converted
  64. Migrating Access Jet Databases to SQL Azure
  65. Migrating Data into SQL Server Using SSMA
  66. Migrating from MySQL to SQL Azure Using SSMA
  67. MySQL to SQL Server Migration: Method for Correcting Schema Issues
  68. Access to SQL Server Migration: Access Solutions using SQL Server, Part 2
  69. Access to SQL Server Migration: Access Solutions using SQL Server, Part 1
  70. Using SSMA Project Setting to Customize Database Migration
  71. Access to SQL Server Migration: Understanding Data Type Conversions
  72. Access to SQL Server Migration: Handling Schema Migration Issues
  73. To Schema or Not To Schema
  74. Saving Comments During Migration
  75. MySQL to SQL Server Migration: How to Use SSMA
  76. Video: Resolving Migration Issue in MySQL
  77. Video: Migrating MySQL Data
  78. Video: Converting MySQL Schema
  79. Video: Installing SSMA
  80. Video: Introduction to SSMA
  81. Video: Automating Database Migration Using SSMA Console Application
  82. Video: Migrating Data Using SSMA
  83. Video: Converting Schema to SQL Server
  84. Video: Analyzing Database Using SSMA
  85. Video: Planning Your Database Migration
  86. Access to SQL Server Migration: How to Use SSMA
  87. Protecting DBA’s secret
  88. Accelerate migration to SQL Server with MAP Toolkit 5.5
  89. A Foreign Affair

2010 16

  1. Part3: Creating a Custom SSMA Report
  2. Part2: Creating a Custom SSMA Report
  3. Part1: Creating a Custom SSMA Report
  4. Database Discovery Made Easy with MAP 5.5
  5. SSMA is now available from WebPI
  6. A Curious Case of NUMBER truncation
  7. "End of Support" for Older SSMA v4.0 family of Products
  8. MySQL to SQL Server 2008 Migration Workshop Video
  9. How To Perform Incremental Data Migration Using SSMA
  10. How To Convert Individual Statement Using SSMA
  11. Installing SSMA Extension Pack on SQL Server Cluster
  12. SQL Server Migration Videos
  13. How To Perform Database Migration Assessment Using SSMA Console Application
  14. How To Migrate Oracle’s Sample HR Schema to SQL Server
  15. Microsoft announces SQL Server Migration Assistant for MySQL
  16. Welcome to SQL Server Migration Assistant Team's Official Blog site