MSSQL Export Data-Tier Application Error SQL71501, SQL71562

Good day, I using latest SSMS and export Data-Tier Application facing error Error SQL71501, SQL71562.

I attach with my log.

can I know how I can solve this 2 error ?

SQL Server

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

13,690 questions Sign in to follow SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

528 questions Sign in to follow 2 comments Hide comments for this question Report a concern I have the same question I have the same question 0 votes

GeethaThatipatri-MSFT 29,382 Reputation points • Microsoft Employee 2023-05-11T02:09:27.55+00:00

Hi, @Kelvin Shee Welcome to the Microsoft Q&A forum, Thanks for posting your question. Can you please share more information, are you attempting to export a database as a BACPAC file using SSMS and getting this error message? Regards Geetha

0 votes Report a concern

GeethaThatipatri-MSFT 29,382 Reputation points • Microsoft Employee 2023-05-16T19:51:29.8633333+00:00

@Kelvin Shee Did you had the chance to check the below reply, Please let us know if you are still facing the same issue? Regards Geetha

0 votes Report a concern Add comment

2 answers

Sort by: Most helpful Most helpful Newest Oldest

LiHongMSFT-4306 26,791 Reputation points 2023-05-11T02:46:45.3766667+00:00

Hi @Kelvin Shee Regarding Error SQL71562, it is an error usually seen in stored procedures after migrating to Azure. The error is seen when something has a four-part table reference. For example: [SEMR].[CDD].[Tooth].[ctcm] . These are not supported and result in a SQL 71562 error. You may be able to identify the issue by querying your [sys] tables for procedures and views that specifically reference a server or database. For stored procedures:

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id) FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE '%[DB_NAME]%'--replace

Regarding Error SQL71501, please refer to this blog: Error sql71501 on exporting azure sql database. Best regards, Cosmog Hong If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 comment Show comments for this answer Report a concern Kelvin Shee 1 Reputation point 2023-05-11T06:23:24.6233333+00:00

sorry I not expert in SQL DB script, will need you help. [SEMR].[CDD].[Tooth].[ctcm] this actually not reference on four table, actually is one table