Is there a free tool to import SQL Server spatial data into PostGIS?
Specifically I want to be able to provide connection strings to my SQL Server and PostgreSQL instances, specify the table(s) I want to import, and click a button to do the import.
Welcome to Geographic Information Systems Stack Exchange
Geographic Information Systems is a question and answer site for people interested in GIS, Remote Sensing, Photogrammetry, Geodesy and Surveying, as well as Programming/Databases specific to the aforementioned.
It is built and run by you as part of the Stack Exchange network of Q&A sites.
With your help, we are working together to build a library of detailed answers to every question about GIS.
Your most important question is important to us
Asking one, and only one, important question within your Question helps attract prompt and clear Answers.
Your other questions are just as easy to research/ask separately!
Writing at least a paragraph helps make your questions and answers easy to follow.
We're a little bit different from other sites. Here's how:
Ask questions, get answers, no distractions
This site is all about getting answers. It's not a discussion forum. There's no chit-chat.
Just questions...
...and answers.
up vote
Good answers are voted up and rise to the top.
The best answers show up first so that they are always easy to find.
accept
The person who asked can mark one answer as "accepted".
Accepting doesn't mean it's the best answer, it just means that it worked for the person who asked.
Import SQL Server Spatial Data into PostGIS
up vote
14
down vote
favorite
2 Answers
up vote
4
down vote
accept
Ogr2ogr can do this for you, but it is a command line tool.
Here's the reference for MS SQL Server:
http://www.gdal.org/drv_mssqlspatial.html
and Postgres / PostGIS:
answered Feb 3 '17 at 19:50
HeyOverThere
6,52811632
6,52811632
up vote
3
down vote
Using QGIS, load your MSSQL spatial layer into your map canvas.
Ensure you have a connection established to your PostGIS database
Using the QGIS DB Manager, simply connect to your PostGIS database and use the Import Vector Layer tool to import the QGIS layer - the MSSQL spatial layer - into your PostGIS database.
answered May 30 '17 at 20:21
DPSSpatial
11.1k3574
11.1k3574
Get answers to practical, detailed questions
Focus on questions about an actual problem you have faced. Include details about what you have tried and exactly what you are trying to do.
Ask about...
- Specific questions concerning geographic information systems and science
- Real problems or questions that you’ve encountered
Not all questions work well in our format. Avoid questions that are primarily opinion-based, or that are likely to generate discussion rather than answers.
Questions that need improvement may be closed until someone fixes them.
Don't ask about...
- Anything not directly related to geographic information systems
- Questions that are primarily opinion-based
- Questions with too many possible answers or that would require an extremely long answer
Tags make it easy to find interesting questions
All questions are tagged with their subject areas. Each can have up to 5 tags, since a question might be related to several subjects.
Click any tag to see a list of questions with that tag, or go to the tag list to browse for topics that interest you.
Import SQL Server Spatial Data into PostGIS
up vote
14
down vote
Is there a free tool to import SQL Server spatial data into PostGIS?
Specifically I want to be able to provide connection strings to my SQL Server and PostgreSQL instances, specify the table(s) I want to import, and click a button to do the import.
asked Feb 3 '17 at 19:18
FunkMonkey33
745
745
You earn reputation when people vote on your posts
Your reputation score goes up when others vote up your questions, answers and edits.
+5
question voted up
+10
answer voted up
+15
answer is accepted
+2
edit approved
As you earn reputation, you'll unlock new privileges like the ability to vote, comment, and even edit other people's posts.
| Reputation | Privilege |
|---|---|
| 15 | Vote up |
| 50 | Leave comments |
| 125 | Vote down (costs 1 rep on answers) |
At the highest levels, you'll have access to special moderation tools. You'll be able to work alongside our community moderators to keep the site focused and helpful.
| 2000 | Edit other people's posts |
|---|---|
| 3000 | Vote to close, reopen, or migrate questions |
| 10000 | Access to moderation tools |
Improve posts by editing or commenting
Our goal is to have the best answers to every question, so if you see questions or answers that can be improved, you can edit them.
Use edits to fix mistakes, improve formatting, or clarify the meaning of a post.
up vote
9
down vote
Ogr2ogr can do this for you, but it is a command line tool.
Here's the reference for MS SQL Server:
http://www.gdal.org/drv_mssqlspatial.html
and Postgres / PostGIS:
answered Feb 3 '17 at 19:50
HeyOverThere
6,52811632
6,52811632
I appreciate this. It seems a bit complicated, but I'll be trying it out if GeoKettle doesn't work out for me. Also, it seems like it's more into the individual features than I need to be. I basically just need to copy rows from one DB to another, but have it include the geometry fields. Thanks for the info. - FunkMonkey33 Feb 8 '17 at 16:29
Unlock badges for special achievements
Badges are special achievements you earn for participating on the site. They come in three levels: bronze, silver, and gold.
| Student | First question with score of 1 or more |
| Editor | First edit |
| Good Answer | Answer score of 25 or more |
| Civic Duty | Vote 300 or more times |
| Famous Question | Question with 10,000 views |
Sign up to get started
Signing up allows you to:
- Earn reputation when you help others with questions, answers and edits.
- Select favorite tags to customize your home page.
- Claim your first badge: Informed
Looking for more in-depth information on the site? Visit the Help Center
Geographic Information Systems Stack Exchange is part of the Stack Exchange network
Like this site? Stack Exchange is a network of 173 Q&A sites just like it. Check out the full list of sites.
Use comments to ask for more information or clarify a question or answer.
You can always comment on your own questions and answers. Once you earn 50 reputation, you can comment on anybody's post.
Remember: we're all here to learn, so be friendly and helpful!