Release: SQL Server Migration Assistant (SSMA) v7.7

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? Each iteration of the…


Migrating SQL Server databases from AWS EC2 to Azure SQL Database using the Azure Database Migration Service

Amazon Web Services EC2 is a well-known Infrastructure as a Service (IaaS) platform, and several organizations use EC2 to host various RDBMS platforms, including Microsoft SQL Server. Using an IaaS platform in the cloud provides certain advantages, such as ease of application migration, full control of software running in the VM, and simplified integration with…


Azure Database Migration Service – February Updates

Overview We are pleased to announce the latest updates to the Public Preview release of the Azure Database Migration Service (Azure DMS). Addition information about these important updates appears below. Support for additional regions. Users can now provision Azure DMS in the Southeast Asia and West India regions to migrate on-premises instances of SQL Server to Azure…


Automating the end-to-end migration of SQL Server to Azure SQL Database using the Azure Database Migration PowerShell module

As part of the Azure Database Migration Service (Azure DMS) Public Preview, we have released a PowerShell library to automate bulk database migrations from SQL Server to SQL Azure Database. Currently, the Azure DMS documentation includes a “How to” article for Migrating SQL Server on-premises to Azure SQL Database by using Azure PowerShell. However, several…


Release: Data Migration Assistant (DMA) v3.4

Overview The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move your schema, data, and uncontained objects from your…