Storing the_geom data from Carto on Azure SQL Server

Question

The column is of geometry type on Carto, however I can't seem to be able to use the geometry type in Azure SQL Server to store it in the database. The column looks like this:

Any help or advice on how to do this would be appreciated. Thanks in advance.

Answer 1

It seems you cannot directly store Carto data into Azure SQL, Try exporting Carto data into Geo JSON format and from there import the data into an Azure SQL database table. Here you will find a tutorial on how to export data from Carto.

Here you will find how to load Geo JSON data into SQL Server (it can be applied to Azure SQL)