Global Mapper full version is a great GIS application for Windows that you should have. This software can do many things and supports almost any spatial file formats. Today, I am going to show you how to export vector layer to SQL Server from Global Mapper. On my previous post, we have learned how to export vector layer to PostGIS from Global Mapper. You may use ogr2ogr command line tool to export spatial data to SQL Server. But it doesn’t have a graphical interface that makes it a little bit harder for new users. If you own Global Mapper, you can use this software to export and migrate your spatial database to SQL Server with ease.
Steps to Export Vector Layer to SQL Server on Global Mapper
Step 1. Create a New Connection to SQL Server
First, let’s prepare a new connection to the SQL Server. If you don’t have an SQL Server on your network, you can install it by following this guide to install SQL Server Container on Windows. Next, we can create a new connection on Global Mapper. Go to File | Open Spatial Database. A new window will open up. Click New to create a new connection.
- Select SQL Server from the Spatial Database Type.
- Give a name for the new connection
- Provide the SQL Server and database credentials
- Test Connection and Click OK.
Step 2. Export Vector Layer to SQL Server
- Open the vector layer in Global Mapper.
- Go to File | Export | Export Vector Spatial Database.
- Select Spatial Database Connection and click OK
- Choose the SQL Server connection. Click Open
- Give a name for the layer in the server
- Click OK
Done. Now your vector layer is saved in the SQL Server spatial database. Thanks for reading this tutorial and see you in the next tutorial. Cheers.