DataBase Export in Azure Sql Database

Question

One or more unsupported elements were found i n the schema used as part of a data package. Error SQL71501: Error validating element [dbo].[viewname]: View: [dbo].[viewname] 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: [dbo].[tablename2].[column1], [dbo].[tablename2].[column1], [dbo].[tablename3].[column1], [db

Answer 1

Hi Siva Prasad,

Welcome to Micrsoft Q&A forum.

As I understand, you are getting error when Export of Azure SQL DB is performed.

Please refer to the below Blogpost link which illustrates error and it's solution:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-198-getting-the-error-quot-has-an-unresolved/ba-p/3288371

Other useful links are:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/exporting-a-database-that-is-was-used-as-sql-data-sync-metadata/ba-p/369062

https://learn.microsoft.com/en-us/answers/questions/1145322/unable-to-export-the-sql-bacpac-filr-from-azure-sq

Let us know if this helped or have further queries.

Thanks