Forum Discussion

architectscott1's avatar
architectscott1
Copper Contributor
Feb 08, 2019

SQL Server CTP 2.2 - Creating an External Data Resource

I am pretty fruastrated with SS2019 CTP 2.2 -- the documentation does not agree with the release.

 

I am trying to create an external table with the table source in SQL Server -- the local instance has Polybase installed and running ... I have tried to use Azure Data Studio (but that tool needs a LOT of work ...) -- so now I am just trying to script the solution

 

In the following command:

CREATE EXTERNAL DATA SOURCE RemoteAcmeDB WITH
(TYPE = RDBMS,
LOCATION = 'SS2019Managed.database.windows.net',
DATABASE_NAME = 'dbAcmeAzure',
CREDENTIAL = acmeCred
);

 

I get the following error --

Msg 102, Level 15, State 1, Line 16
Incorrect syntax near 'RDBMS'.

 

Ummm ... so something is amiss as the documentation says that this is a valid option 

Can anyone help me with this -- have MS support working on this as well but no answer (and now it has been a couple of weeks)

 

regards

 

scott

No RepliesBe the first to reply

Resources