Forum Discussion
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