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

Assess an Enterprise With Data Migration Assistant–Part 2: Running an Assessment

In my previous post I took you through the prerequisites for successfully running a scaled assessment against your SQL Server enterprise. In this post I’ll take you through how to run a scaled assessment using the dmaDataCollector PowerShell script.   Running a scaled assessment Ensure that the PowerShell modules have been loaded into the modules…

2

Assess an Enterprise With Data Migration Assistant–Part 1: Prerequisites

In my previous posts How to Consolidate JSON Assessment Reports and Report on Your Consolidadted Assessments With PowerBI, I show how to run scaled DMA assessments across your estate and report on the results using PowerBI. In the next series of posts I’ll take you through the enhancements to the process, scripts and reports to…

0