Azure SQL export

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 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##].
 (Microsoft.SqlServer.Dac)


——————————


This is due to references from the Database to the Elastic Jobs DB

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

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...