Monthly Archives: November 2018

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool Contents Introduction Microsoft Database Migration Assistant (DMA) tool Migrate SQL Server database To Azure SQL Instance using DMA tool Detecting the compatibility issues using Assessment Type … Continue reading

Posted in Azure, Migration to Azure SQL Database | Tagged , , , , | 33 Comments

How to migrate SQL Database to Azure SQL Database using SSMS Export/Import

Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents Introduction Creating the .bacpac file using SSMS Export Importing the .bacpac file using SSMS Import Summary Introduction There are many ways of migrating the On premise SQL Database to … Continue reading

Posted in Azure, Migration to Azure SQL Database | Tagged , , , | 27 Comments

Difference between Stored Procedure and Trigger

Difference between Stored Procedure and Trigger     SQL Stored Procedure & SQL Triggers, both are the important objects of SQL. SQL stored procedure are the set of logically group of SQL statements which are a group to perform a … Continue reading

Posted in Imp SQL Difference, SQL Server, SQL Stored Procedure | Tagged , , , | 15 Comments

Advantages of SQL Stored Procedure

SQL Stored procedure are the set of logically group of SQL statement which are grouped to perform a specific task. Stored procedure are better than the inline SQL queries as they help in securing the database from SQL Injection. It … Continue reading

Posted in SQL Server, SQL Stored Procedure | Tagged , , | 32 Comments

Advantages & Disadvantages of SQL Trigger

Advantages & Disadvantages of SQL Trigger Introduction Triggers are database objects which are needed to perform some predefined action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified┬átables. Triggers are … Continue reading

Posted in SQL Server, SQL Triggers | Tagged , | Leave a comment

How to migrate SQL Database to Azure SQL Database using SSMS deploy

Migrating SQL Database to Azure SQL Database using SSMS Deploy     In the previous articles, we had introduction about the Azure SQL Database, Azure Service Tiers and pricing models, Creation of Azure SQL Database & How to connect with … Continue reading

Posted in Azure, Migration to Azure SQL Database | Tagged , , , | 2 Comments