Error while deploying NAV DB from SQL to Azure SQL

EkinEkin Posts: 26Member
edited 2019-03-12 in NAV Three Tier
Hello everyone,

I am having some difficulties with importing NAV DB from SQL Server to Azure SQL Server. I exported DB using Export Data-tier Application and trying to import it back using Import Data-tier Application. I googled the error but cannot find any solution. Does anyone familiar with this issue?


SQL Error:

Could not import package.
Warning SQL0: A project which specifies SQL Server 2016 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.
Error SQL72014: .Net SqlClient Data Provider: Msg 208, Level 16, State 1, Procedure deadlock_report_ring_buffer_view, Line 3 Invalid object name 'sys.dm_xe_session_targets'.
Error SQL72045: Script execution error. The executed script:
CREATE VIEW dbo.deadlock_report_ring_buffer_view
SELECT target_data AS event_raw_data
FROM sys.dm_xe_session_targets AS xt
sys.dm_xe_sessions AS xs
ON xs.address = xt.event_session_address
WHERE = N'..._deadlock_monitor'
AND xt.target_name = N'ring_buffer';


Thank you for your help.


Best Answer

  • EkinEkin Posts: 26
    Accepted Answer

    I've just removed SQL view called "deadlock_report_ring_buffer_view" from the database and successfully imported the DB, I've read some articles and apparently azure deals with deadlock by itself already. However, I don't know what the outcome will be.



Sign In or Register to comment.