Data Migration Assistant The Data Migration Assistant is migration tool developed by Microsoft. The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL database. DMA recommends performance and reliability improvements for your target […]
Author: Prashant Pawar, Cloud Engineer. In the digital era nowadays, a good database is crucial to any company or organization. This is because the database stores all the pertinent details about the company. Microsoft Access is a relational database. A relational database is a collection of data items organized as a set of tables. Access […]
Author – Pranjal Rele, Associate Cloud Engineer Introduction: Incremental Load is defined as the activity of loading only new or updated records from the database into an established QVD. A QVD (QlikView Data) file is a file containing a table of data exported from QlikView. Reading data from It is also sometimes called as Delta Load. […]
Author – Amit Singh, Cloud Engineer Business continuity and disaster recovery (BCDR or BC/DR) is a set of processes and techniques used to help an organization recover from a disaster and continue or resume routine business operations. It is a broad term that combines the roles and functions of IT and business in the aftermath […]
Have you ever been in a situation where migration became an issue for you? I was in a fix whether how one should migrate only the schema part, In such cases one can use the tool known as Data Migration Assistant. The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by […]
Offline Migration Migration Steps (SQL Server to Azure SQL Database) Prerequisites: Create a Vnet for DMS Vnet’s nsg should not block communication ports 443, 53, 9354, 445, 12000 Configure your windows firewall open port 1433 If you’re running multiple named SQL Server instances using dynamic ports, you may wish to enable the SQL Browser Service […]
Online migration Migration Steps (SQL Server to Azure SQL Database) Prerequisites: Create a Vnet for DMS Vnet’s nsg should not block communication ports 443, 53, 9354, 445, 12000 Configure your windows firewall open port 1433 If you’re running multiple named SQL Server instances using dynamic ports, you may wish to enable the SQL Browser Service […]
Two major deadlines have been looming for organisations that use older versions of popular Microsoft products. SQL Server 2008 and SQL Server 2008 R2 reach their end of support on July 9. Windows Server 2008 and Windows Server 2008 R2 will hit their deadline six months later, on Jan. 14, 2020. What Does the End […]
Introduction: Today many companies have their data which resides not only on the on-premises but also on cloud hosted at the Microsoft Azure data centre. There is an increasing need to maintain the sync between both the servers. In order to maintain the same Microsoft SQL has supported replication services. Transactional replication is a […]
In our previous blog SQL Database Managed Instance, we saw an overview of Managed Instance of SQL database. In this article, we compare Azure SQL database and SQL Database Managed Instance and walk you through database migration. The following table outlines key differences and envisioned usage scenarios between SQL IaaS, Azure SQL Database, and SQL […]
