Release: Database Experimentation Assistant (DEA) v2.5

Overview Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any new version of the SQL Server will be able to…


Database Migration Guide – March 2018 updates

What’s new with the latest updates? Expanded migration guidance for PostgreSQL to Azure Database for PostgreSQL and MySQL to Azure Database for MySQL. New guidance for migrating SQL Server to Azure SQL Database Managed Instance using the Azure Database Migration Service. A more refined overview graphic for the database migration process. Scenario structure updated to…


Ready to migrate MySQL workload to Azure Database for MySQL?

The Azure Database Migration Service (DMS) is a robust and rich migration orchestration engine that you can use to move your on-premises databases to Azure. With the recently announced General Availability (GA) of Azure Database for MySQL, DMS also released the capability of migrating on-prem MySQL to Azure Database for MySQL for those customers who…

0

Troubleshoot Site-to-Site VPN Connectivity Issues with On-Premises Source DB for Azure Database Migration Service

The Azure Database Migration Service is a fully managed service designed to enable seamless migrations from multiple database sources to Azure Data platforms with minimal downtime. For Azure Database Migration Service to be able to connect to on-premises source it requires either one of the following Azure hybrid networking prerequisites: Express Route Site-to-Site VPN What…


Migrating SQL Server databases from a Google Compute Engine instance to Azure SQL Database using the Azure Database Migration Service

Google Cloud Platform is a suite of public cloud computing services offered by Google. The platform includes a range of hosted services for compute, storage, and application development that runs on Google hardware. Google Cloud Platform (GCP) services can be accessed by software developers, cloud administrators, and other enterprise IT professionals over the public internet…


Migrating data On-Premises to Azure with the new Azure Database Migration Service (VPN Site-to-Site)

Recently Microsoft announced the Public Preview Azure Database Migration Service (Azure DMS), a new way to migrate your data from a SQL Server database or from other sources to Azure: https://blogs.msdn.microsoft.com/datamigration/2017/11/15/announcing-the-azure-database-migration-service-public-preview/ Thinking about it, I did this tutorial to show how can you migrate a SQL Server database On-Premises to the Azure using the Azure…


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

Amazon Web Services Relational Database Service is a well-known platform that several organizations use to host various RDBMS offerings, including Microsoft SQL Server. Customers, after an initial foray into the cloud using RDBMS on platform such as AWS RDS, decide to move to a PaaS (Platform as Service) RDBMS offering, such as Microsoft Azure SQL…


Azure Database Migration Service – March Update

Overview We are pleased to announce the latest update to the Public Preview release of the Azure Database Migration Service (Azure DMS): Support for migrations from SQL Server to Azure SQL Database Managed Instance! Azure DMS now supports on-premises SQL Server database migrations to Azure SQL Database Managed Instance. Azure DMS reduces the complexity of cloud migrations…


Assess an Enterprise With Data Migration Assistant–Part 4: Report on an Assessment

In my previous post I took you through how to consume the assessment data into the DMAWarehouse. In this post I’ll take you through the PowerBI report to visualize your upgrade / migration readiness.   DMA Reports If you haven’t already downloaded the PowerBI desktop then download it here. Open the DMA Reports PowerBI template…

0

Assess an Enterprise With Data Migration Assistant–Part 3: Loading an Assessment

In my previous post I took you through how to run a scaled assessment using the dmaDataCollector PowerShell function. In this post I’ll take you through how to consume the assessment JSON output using the dmaProcessor PowerShell function.   Consuming the assessment JSON file Once your assessment has finished you are now ready to import…

2