We'll get to know the techniques:
1. Connect to Azure SQL Database (AZURE PORTAL, CONNECT WITH, VISUAL STUDIO):
You
- can connect SQL Server Data Tools (SSDT) to Azure SQL Database directly from Visual Studio. This allows you to develop and manage database schemas and objects.
2. View available SQL Server instances and objects
(SQL SERVER OBJECT EXPLORER):
SQL Server
- Object Explorer in SSDT allows you to view available SQL Server instances and objects, making it easier to navigate and manage your databases.
3. Compare schema between SQL Server On-Premises and Azure SQL Database (SCHEMA COMPARE):
- The schema comparison feature allows you to compare the structure of objects between an on-premises environment and an Azure SQL Database by identifying differences.
4. Identify different objects between instances (OBJECT DEFINITION, ADD, TABLE):SSDT
- HELPS IDENTIFY DIFFERENT OBJECTS, SUCH AS TABLES, BETWEEN INSTANCES. You can view the object definitions and decide on the actions to take.
5. Update the schema on the target Azure SQL Database instance (UPDATE):
- Based on the schema comparison, you can update the schema on the target instance in Azure SQL Database
.
6. Compare existing data between On-Premises and Azure SQL Database tables (DATA COMPARISON):
- The data comparison feature allows you to identify differences between data from tables in on-premises environments and in Azure SQL Database.
7. Identify different records (DIFFERENT RECORDS, ONLY IN
SOURCE, ONLY IN TARGET, IDENTICAL RECORDS): You
can identify different records, unique records in the
- source environment, unique records in the target environment, and identical records during data comparison.
8. Update the records in the target Azure SQL Database instance (UPDATE TARGET):
- Based on the data comparison, you can update the records in the target instance in Azure SQL Database.
9. Visualize the data in the Azure SQL
Database instance (VIEW DATA):
- SSDT allows you to view the data directly in the Azure SQL Database instance, making it easier to analyze and manage the stored data.