Azure Learning #4 Data Sync configuration fails with error “Failed to update database ‘xxxxx’ because the database is read-only”

Recently I came across a customer who encountered the following error when configuring Azure Data Sync . Database re-provisioning failed with the exception ‘SqlException Error Code: -2146232060 – SqlError Number:3906, Message: Failed to update database ‘xxxxx’ because the database is read-only. SqlError Number:2759, Message: CREATE SCHEMA failed due to previous errors. For more information, provide…

0

Azure Learning #3 Using Azure Database Migration Assistant

The purpose of writing this blog is to explain the difference in behavior when you assess a database and migrate a database using DMA With the assessment option you can select an On-Premise Source Server and Target Server to be Azure DB, SQL server on Azure VM or On-premise SQL Server With the migration option…

0

Azure Learning #2 Using Azure Data Warehouse Migration Utility

The purpose of writing this blog is to get you familiarized with the very benefits of Azure Datawarehouse Utility which is still a preview feature. The utility can be downloaded at the below link https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-migrate-migration-utility Once you have installed the utility you will find the below shortcut created on your desktop Root path : C:\Program…

0

Azure Learning #1 Connectivity errors from External Network to Azure database

This blogs aims at troubleshooting connectivity errors observed when trying to connect via SSMS or other client drivers from your corporate network or public network to azure database. You may find similar blogs however this blogs collates all the information available for such issues. We as engineers often come across scenarios where customer’s have tried…

0