1
Vote

SQLAzureMWBatchBackup: unable backup external data source and external tables

description

Hello Colleagues,

I'm doing backup of SQL Azure DB. In that DB we have external data source (Elastic Database queries, type RDBMS) and external tables.

We have 3 issues here:
  1. External data sources unable to be processed. I can't find any "CREATE EXTERNAL DATA SOURCE" in result .sql file.
  2. I've received next message during backup operation:
Table hints are not supported on queries that reference external tables.
As result all EXTERNAL TABLES recorded in result .sql file as:
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Schema1].[Table1]') AND type in (N'U'))
BEGIN
CREATE TABLE [Schema1].[Table1](
    [ColumnName] [nvarchar](1500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ExportTypeID] [int] NULL,
    [IDX] [int] NULL,
    [CSVName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DBID] [int] NULL
)
END
But should be:
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Schema1].[Table1]') AND type in (N'U'))
BEGIN
CREATE EXTERNAL TABLE [Schema1].[Table1] 
(  
     [ColumnName] NVARCHAR(1500),
     [ExportTypeID] INT,
     [IDX] INT,
     [CSVName] VARCHAR(100),
     [DBID] INT
)
WITH  
(  
    DATA_SOURCE = [ExternalDataSource]
) 
END
  1. DATABASE SCOPED CREDENTIAL are not processed at all.
Thanks for help.

comments

ghuey wrote Nov 18, 2016 at 12:08 AM

Hi,

I retired from Microsoft a little over a year ago and I never got the chance to work with elastic databases and SQLAzureMW does not handle this. I don't think anybody from Microsoft has picked up SQLAzureMW so I don't know if it ever will. The code is open source so if anybody wants to fix it up ...

If anybody from Microsoft sees this, here is a request to add to your list.

Regards,
George