MS SQL Migration Toolkit について

あらゆるデータソースをMicrosoft SQL Server及びAzure SQLに、またはその逆に変換

MS SQL Migration Toolkit is a software pack to convert any data source to Microsoft SQL Server or SQL Azure and vice versa. The product has high performance because it does not use ODBC or any other middleware software. Command line support allows to script, automate and schedule the conversion.

MS SQL Migration Toolkit includes the following tools:

  • Access-to-MSSQL migrates Microsoft Access databases to SQL Serveror Azure SQL. All versions of Microsoft Access (includingMS Access 2016) are supported. The program can processMS Access databases protected with password or user-levelsecurity.
  • DB2-to-MSSQL migrates IBM DB2 databases to SQL Server orAzure SQL. All versions of IBM DB2 are supported.
  • DBF-to-MSSQL migrates DBase/FoxPro/Clipper (*.dbf) databasesto MS SQL server or Azure SQL. All formats of DBF files and MEMOfiles are supported.
  • Excel-to-MSSQL converts Microsoft Excel spreadsheet intoMS SQL or Azure SQL database. All versions of MS Excel aresupported (including MS Excel 2016).
  • MSSQL-to-Access converts SQL Server or Azure SQL databasesinto Microsoft Access format. MS Access 97/2000/2010 formatsare supported.
  • MSSQL-to-Excel converts SQL Server or Azure SQL databasesinto Microsoft Excel spreadsheets. Option to filter datausing SELECT-queries.
  • MSSQL-to-MySQL migrates SQL Server or Azure SQL databases to MySQL server.All versions of Linux/Unix and Windows MySQL servers are supported.The program can also export data into MySQL dump files.
  • MSSQL-to-Oracle migrates MS SQL or Azure SQL databases to Oracle server.All versions of 32- and 64- bit Windows and Linux/Unix Oracleservers are supported.
  • MSSQL-to-PostgreSQL migrates Microsoft SQL or Azure SQL databases to PostgreSQLserver.
  • MySQL-to-MSSQL migrates MySQL databases to SQL Server or Azure SQL.All versions of Linux/Unix and Windows MySQL are supported.
  • Oracle-to-MSSQL migrates Oracle databases to SQL Server or Azure SQL.
  • PostgreSQL-to-MSSQL migrates PostgreSQL databases to Microsoft SQL or Azure SQLserver.
  • SQLite-to-MSSQL migrates SQLite databases to Microsoft SQL or Azure SQLserver.

Features

  • All versions of Microsoft SQL Server are supported (including Azure SQL).
  • Converts table structures and data with all necessary attributes.
  • Option to synchronize destination database with the source data.
  • Converts indexes, foreign keys and queries (views).
  • Option to filter data using SELECT-queries.
  • Stores conversion settings into profile.
  • Command line support.
  • Easy-to-use wizard-style interface.
  • Quick Launch.
  • Full install/uninstall support.
  • The product can be customized according to customer requirements.
  • Unlimited 24/7 support service.
  • 1-year subscription for updates.