Storing the_geom data from Carto on Azure SQL Server

Gabriel Armando Alvarez Ramirez 26 Reputation points
2021-12-01T09:44:11.833+00:00

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: 154111-image.png

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

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,706 Reputation points MVP
    2021-12-01T13:13:07.363+00:00

    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)


0 additional answers

Sort by: Most helpful