Problem Recently, our client has been planning to use Azure platform and one of the most important factor is to migrate their data from MongoDB Atlas into Azure Cosmos DB. In this article, I would like to summary some necessary steps to migrate data from MongoDB. Pre-migration Before we start migration process, it requires us … Continue reading How to migrate data from MongoDB Atlas to Azure Cosmos DB?
In this article, I would like to instruct you how we use Geo-Replication to set High Availability up for Microsoft SQL Azure Database. Prerequisite condition The following article gives some basic steps to create a SQL Database in Microsoft Azure Introduction Active Geo-Replication is Azure SQL Database feature that allows you to create readable replicas … Continue reading How to configure Fail-over and Geo-Replication for Microsoft Azure Database
In this article, I would like to instruct you the way how to load a text file to Azure SQL Database that you created with Azure Data Factory. See the following articles before going ahead How to create Storage Account? How to create SQL Database? How to upload a file to Storage Accounts? For demo … Continue reading How to create a Pipeline to load a text file to Azure SQL Database with Azure Data Factory
In this article, I instruct you how to upload a file to Blobs in Azure Storage Account. Step 1: Create a container in Blobs Before you can upload a file to Blobs, you need to create a container Go to Storage Account resource ddazurestoragerespo Click on Blobs Click on + Container and enter ddcontainer Click … Continue reading How to upload a file to Azure Storage Account
In previous article, I instructed you how to create a repository where we can storage our data files such text files... as data source. Today, I instruct the way how to create a Azure SQL Database as a destination when we would like to import data from some files in Azure Storage. Prerequisite condition To … Continue reading How to create a Azure SQL Database
This is the prerequisite step when we start studying about Microsoft Azure Data Factory and we need to build a pipeline to copy data from a text-file, database to Azure SQL Database. Prerequisite condition To create a Azure Storage Account, you must have Azure Subscription Azure Storage Account Step 1: Login to Azure Portal with … Continue reading How to create a Azure Storage Account in Azure Portal
Situation Microsoft introduced a great feature in SQL Server 2016 that support JSON data. However, you can get the error Invalid object name OPENJSON when you work on databases that their compatibility level are lower than 130. Solution To fix this error, you need to update your database compatibility to 130 ALTER DATABASE <Database … Continue reading How to fix “Invalid object name OPENJSON” in SQL Server 2016