SQL SERVER – Migration Assistant for Access, MySQL, Oracle, Sybase

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Sybase Adaptive Server Enterprise (ASE) to SQL Server or SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.

SSMA for Access 5.0
Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server or SQL Azure.

SSMA for MySQL 5.0

Microsoft SQL Server Migration Assistant (SSMA) for MySQL is a tool to automate migration from MySQL database to SQL Server or SQL Azure.
SSMA for Oracle 5.0
Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database to SQL Server.

SSMA for Sybase 5.0
Microsoft SQL Server Migration Assistant (SSMA) for Sybase is a tool to automate migration from Sybase ASE database to SQL Server or SQL Azure.

Reference: Pinal Dave (https://blog.sqlauthority.com)
,
Previous Post
SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?
Next Post
SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012

Related Posts

3 Comments. Leave new

  • Hi
    Unfortunately for the Oracle server connection is failed. provider oracle clinet using the error :
    “Connection to Oracle failed.
    System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. ”
    and oledb provider using the error:
    “Error finding Oracle OLE DB provider.Requested registry access is not allowed.”
    will you please help? Thanks contents good

    Reply
  • Nice post. Here’s how you can move or convert Microsoft Access to web in minutes

    Reply
  • Hi, When i connecting Sybase database through SSMA, it shows error message as “Unable to find provider : Sybase Data Access Connectivity libraries were not found on the machine. You can install them from Sybase product media or download it from Sybase web site.”

    Can you please help on this..?

    Reply

Leave a Reply

Menu