Database Schema Compare Tool
Migration to Azure SQL is far easier than before. Availability of Schema migration, Database migration, Database comparison, Schema comparison tools from Microsoft makes migration easier and risk free. This blog is about how the Database Schema comparison tool can be used to perform Db2 and Azure SQL Schema comparison.Resolving ADF Copy Upsert Failures in SQL DB for XML Columns
Customers modernizing their Oracle, Mainframe/Midrange Db2, Sybase and other databases to Azure SQL often use Azure Data Factory (ADF) for data transfer. For large datasets, an initial copy is made a few days prior, followed by incremental data copies during cutover. The ADF Copy activity's Upsert method is common for these incremental transfers, but this method fails for tables which contain XML columns. This blog explains using Stored Procedure as the Sink behavior in Copy activity to perform Upsert into Azure SQL Database. Same method can be used even when target is Azure SQL MI or Azure SQL VM.
Migrating Mainframe RACF user identities to Microsoft Entra ID Users
RACF[Resource Access Control Facility] is one of the main security components which does authorization and authentication on the Mainframe. While modernizing mainframe workloads to Azure, there is a need to migrate the identity information of the users to Azure. This also applies in co-existence and hybrid scenarios where both mainframe and Azure user information needs to stay in sync.Db2 to Azure SQL DB parallel data copy by generating ADF copy activities dynamically
Want to utilize near to full network bandwidth / CPU resources on source and target to perform efficient data copy from Db2 to Azure SQL? Follow this tech article to know more about how ADF can be utilized for this purpose.Mainframe Db2 Data Virtualization using SQL Server PolyBase
Looking for easy solution to combine data between Db2 and SQL Server in single query? Want to know more about how to access Db2 table from SQL Server real time without duplicating data between Db2 and SQL Server? Look no further PolyBase is the answer to these questions as explained in this article.
