Is it possible to use FME to convert a SQL MapInfo database into an ESRI SQL database? What are the steps needed to complete this task?
Solved
How to convert a MapInfo SQL database into an ESRI SQL database
Best answer by redgeographics
I assume you mean MapInfo SpatialWare, which is a supported format, so are various ESRI database flavors. So the short answer is: yes, this is possible. Depending on which specific ESRI database format you want to write to you may need at least an FME ESRI edition and ArcGIS licensed on the same computer, in other cases an FME Professional edition could be enough.
The steps you need to take can be as simple as using the FME Quick Translator, selecting your input database and your output database and hitting run. A next step up would be generating a workspace in the FME Workbench. This would be better if you want to repeat the process on a regular basis or make changes to the data during the process.
If you want to make a quick start, I'd recommend going through chapter 1 of the FME 2017 Desktop Basic Training Course.
If you have more specific questions about the data transformation process feel free to ask here.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+59- Celebrity
- 3697 replies
- Best Answer
I assume you mean MapInfo SpatialWare, which is a supported format, so are various ESRI database flavors. So the short answer is: yes, this is possible. Depending on which specific ESRI database format you want to write to you may need at least an FME ESRI edition and ArcGIS licensed on the same computer, in other cases an FME Professional edition could be enough.
The steps you need to take can be as simple as using the FME Quick Translator, selecting your input database and your output database and hitting run. A next step up would be generating a workspace in the FME Workbench. This would be better if you want to repeat the process on a regular basis or make changes to the data during the process.
If you want to make a quick start, I'd recommend going through chapter 1 of the FME 2017 Desktop Basic Training Course.
If you have more specific questions about the data transformation process feel free to ask here.