Migarting Different Schemas between Azure SQL database using ADF

Migarting Different Schemas between Azure SQL database using ADF

Author: Ankit Gupta (Associate Data Engineer), Hitesh Srivastava (Associate Data Engineer) This article describes how to migrate selected tables with different schema from one Azure SQL database to another Azure SQL database through Azure Data Factory. Prerequisites: Two Azure SQL databases (Source with a sample database and destination) Azure Data factory SSMS Step 1: Connect…

Database migration from Managed Instance to SQL Server with transactional replication

Author- Ashfaq Pathan (Associate Data Engineer) Transactional Replication Setup We will set up a transactional replication for migrating the database from Managed Instance to SQL Server 2017 hosted on Azure SQL-VM. Managed Instance will be both Publisher and Distributor. SQL Server will be Subscriber. Prerequisites: 1. Azure Subscription. 2. Storage account with one file-share in it…

ELK Stack

Installation of ELK Stack on CentOS

Author: Prashant Pawar, Cloud Engineer   The ELK Stack — is a collection of open-source software Elasticsearch, Logstash, and Kibana on the server side, along with Filebeat on the client side which allows you to search, analyse, and visualize logs generated from any source in any format, a practice known as centralized logging. The Elastic Stack has four main components: Elasticsearch: a distributed RESTful search…

Elastic querying on Azure SQL Database

Author – Moulshree S. D., Sr. Data Engineer On-premises SQL Server does support three- or four-part names, but the Azure SQL Database does not. The Elastic Database query feature enables you to run a Transact-SQL query that spans multiple Databases in Azure SQL Database. The Database migration Assessment throwing error as “Cross-Database queries using three-…