Recently I was trying to Export a Azure database to a bacpac file , however SQL Management Studio gave the following error<\/p>
——————————<\/p>
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71501: Error validating element [jobs_internal].[visible_targets_formatted]: View: [jobs_internal].[visible_targets_formatted] 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: [jobs_internal].[database_credentials].[C], [jobs_internal].[database_credentials].[name] or [jobs_internal].[targets].[C].
Error SQL71501: Error validating element [jobs]: Schema: [jobs] has an unresolved reference to object [##MS_JobAccount##].
Error SQL71501: Error validating element [jobs_internal]: Schema: [jobs_internal] has an unresolved reference to object [##MS_JobAccount##].
\u00a0(Microsoft.SqlServer.Dac)<\/p>
——————————<\/p>
This is due to references from the Database to the Elastic Jobs DB<\/p>
The way around this is to Copy the database to another database in azure, remove the references on SQL to the Elastic Jobs DB then Export this Database<\/p>","protected":false},"excerpt":{"rendered":"
Recently I was trying to Export a Azure database to a bacpac file , however SQL Management Studio gave the following error——————————One or more unsupported elements were […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3914,1464,736,3912,2767,3913,3915],"class_list":["post-6014","post","type-post","status-publish","format-standard","hentry","category-research","tag-ms_jobaccount","tag-azure","tag-backup","tag-bacpac","tag-export","tag-has-an-unresolved-reference-to-object","tag-jobs_internal"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=6014"}],"version-history":[{"count":3,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6014\/revisions"}],"predecessor-version":[{"id":6254,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6014\/revisions\/6254"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=6014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=6014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=6014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}