SQL Compare 12 & SQL Source control - doesn't handle SQL Azure External Tables

Mick

Hi folks,
I've got a couple of sprocs that create all the external table references and source control would not parse them at all.

e.g. CREATE EXTERNAL TABLE ....

Also when using SQL Compare - it views these tables as local tables to the Azure DB.

Would be awesome for a future version given this is a main technique (at the moment) to reference cross db tables in Azure.

Cheers,
Mick

sam.blackburn

We're still looking into the remaining SQL Server 2016 features and trying to find out which ones people tend to use.

The UserVoice request for this feature has a handful of votes for it, and we'd like to have a good list of people to contact with some questions about their use case before we proceed.

For example, we'd like to know whether most people who want this feature are using Azure Data Warehouse, and whether they would be better off using Data Platform Studio instead of Compare.

spacattac

we have some external table references as well in our SQL Azure databases and would benefit from this capability in SQL Compare.  we're not using Azure Data Warehouse - just SQL Azure dbs.

vot

Great if we can have external tables.

peterhci

we have multiple servers with external tables(mongodb). Redgate's value would b greatly enhanced with external table capability, ( comparing mapped regular tables with external tables)