SAP Data Intelligence - MSSQL Server, Azure SQL DB Server

[former_member805363]

Hi Everyone,

We have created connections to Azure SQL Databases and MSSQL Databases in SAP Data intelligence.

During the data migration from SQL DB into SAP DI Data lake, will the source tables in SQL DB get locked for Read and Write operations?

For example: If we are replicating the data from TABLE A of SQL Database into ADL via SAP DI, during the execution of the replication task, will I be able to execute Insert or update statements for this table in the SQL server.

Thanks and Regards,
Bharath

[Lee]

Hi Bharat

Are you getting any error while doing the replication? Can you share what error are you getting?

Also, how are you replicating? Is it through flowagent sql or table replicator?

Regards , Leena

[ivy_wang3]

Hi Bharath,
During initial load phase, RMS performs SELECT queries on each partition of a source table and it requires Shared Locks on data pages by default. It’s possible to block Insert/Update/Delete operations on these data pages in other user transactions which require Exclusive Locks. Refer to Azure SQL doc: https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-locking-and-row-versioning-guide?view=azuresqldb-current#loc[…]ity

It’s also mentioned in the doc that if READ_COMMITTED_SNAPSHOT database option is set ON, read operations require only SCH-S (schema stability) lock which won’t block update operations. It might be a possible workaround if the possible blocking is an issue for you.