Getting Error SQL71501 while creating Dacpac from SQL Server database

Question

We are in plan of migrating Azure DevOps Server (On-Prem) data to Azure DevOps Services (Cloud).

As part of that, we have initiated the dacpac creation from source database via Visual studio's SQL Server Object Explorer by selecting the option of 'Extract Data tier Application' and facing the below error

> Error SQL71501: Error validating element [Build]. [prc_GetRunnablePausedBuilds]: Procedure: [Build]. [prc_GetRunnablePausedBuilds] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [Build].[tbl_Build]. [BuildId], [Build].[tbl_Definition] .[BuildId] or [Build].[tbl_PausedQueue]. [BuildId].

Please help me to resolve this.

We tried to restore the latest database backup of main server (Source) and retried the same, but not worked.

Answer 1

Hi
Satya Sundaraneedi,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are getting Error SQL71501 while creating Dacpac from SQL Server database.

Please refer to the post here https://www.red-gate.com/simple-talk/blogs/extracting-dacpac-when-sql-server-refuses/ where you may skip validation step and could proceed.

Kindly try if this suits to your requirement and let us know if further queries.

Thanks

Answer 2

If you are doing an export of a database attached to a SQL Server instance, please perform an assessment of the database using Microsoft Data Migration Assistant, resolve de inconsistencies by executing the recommendations the tool gives you, and then you will be able to export the database.

You cannot migrate a database that makes reference to objects (tables, stored procedures, functions, etc.) that reside on other databases on the same server. You may have to recreate those objects inside that database you want to migrate and reference them on the same database, or you will have to remove those cross-database references from the database you want to export/migrate. Please examine the stored procedure [Build]. [prc_GetRunnablePausedBuilds], and you will find it reference objects that no longer exists or that reside on another database.