I need to copy some data from an azure SQl DB instance into my azure data warehouse.
The most obvious way to do this is to use Elastic Query, similar to the below:
CREATE EXTERNAL DATA SOURCE SqlDb WITH (TYPE = RDBMS, LOCATION = 'myServer.database.windows.net', DATABASE_NAME = 'MyAzureSqlDb', CREDENTIAL = MyLogin, ) ;
Which appear to give the below error:
Msg 103010, Level 16, State 1, Line 7 Parse error at line: 2, column: 13: Incorrect syntax near 'RDBMS'.
Which I'm assuming means elastic query isn't supported. Are there any other easy methods to copy data from SqlDb -> SqlDw ? It's sounding like the only alternative is to get an ETL tool to do it.