Unable to generate bacpac/dacpac for Managed Instance databases which include External Tables.

[CliveChallinor]

• SqlPackage or DacFx Version: 15.0.5120.2

• .NET Framework (Windows-only) or .NET Core:

• Currently installed "classic" .NET Versions in the system: 2.0.50727.4927 Service Pack 2 3.0.30729.4926 Service Pack 2 3.5.30729.4926 Service Pack 1 4.0.0.0 4.8.09032

• Environment (local platform and source/target platforms):

Steps to Reproduce:

1. Create a Managed Instance in Azure
2. Create a database in the managed instance

3. Use the following script to generate objects within the database CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'dfgsdfgshrhhnfg_344f'; GO /* specify credentials to external data source

   • IDENTITY: user name for external source.

   • SECRET: password for external source. */ CREATE DATABASE SCOPED CREDENTIAL SqlServerCredentials WITH IDENTITY = 'Clive', Secret = ''; GO

     / Make sure Polybase is enabled /

     sp_configure 'POLYBASE enable',1 reconfigure go

   CREATE EXTERNAL DATA SOURCE SQLServerInstance WITH ( LOCATION = 'sqlserver://we-server.database.windows.net', DATABASE_NAME = N'***_NDW_TEST', -- PUSHDOWN = ON | OFF, CREDENTIAL = SQLServerCredentials, TYPE = RDBMS ); GO

CREATE EXTERNAL TABLE [dbo].[all_dm_exec_requests]([session_id] smallint NOT NULL, [request_id] int NOT NULL, [start_time] datetime NOT NULL, [status] nvarchar(30) NOT NULL, [command] nvarchar(32) NOT NULL, [sql_handle] varbinary(64), [statement_start_offset] int, [statement_end_offset] int, [cpu_time] int NOT NULL) WITH ( DATA_SOURCE = SQLServerInstance, SCHEMA_NAME = 'sys', OBJECT_NAME = 'dm_exec_requests' )

4. Attempt to Extract Data Tier Application from SSMS

5. Fails with the following TITLE: Microsoft SQL Server Management Studio

Could not extract package from specified database. Error 0: An error occurred while attempting to reverse engineer elements of type Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlExternalDataSource: Unsupported external data source type '1'. (Microsoft.SqlServer.Dac)

---

ADDITIONAL INFORMATION:

Unsupported external data source type '1'. (Microsoft.Data.Tools.Schema.Sql)

---

BUTTONS:

OK

Did this occur in prior versions? Yes

(DacFx/SqlPackage/SSMS/Azure Data Studio)

[ErikEJ]

Have you tried with the latest version?

[CliveChallinor]

Have you tried with the latest version?

Yes.....latest SSMS19 Preview