I want to import a subset of my SDE data into an MSSQL Azure spatial database. I can connect and create a table but the no rows get inserted. what is the proper way to configure this?
Question
Convert Esri SDE data to MS-SQL Spatial issues
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.
In theory it should "just work", but it's difficult to say without more detail. Can you perhaps post a minimal workspace showing the general mechanism as well as the complete log file here?
In theory it should "just work", but it's difficult to say without more detail. Can you perhaps post a minimal workspace showing the general mechanism as well as the complete log file here?
This is a simple read/write work bench. It completes but no row show up in the database?
+21- Safer
Hi @brianapeters, can you try connecting the objectid to the primary key on your MSSQL Azure table?
Hi @brianapeters, can you try connecting the objectid to the primary key on your MSSQL Azure table?
A possible cause is the wrong version of the SQL Server CLR Types (The SQL Server System CLR Types package contains the components implementing the new geometry, geography, and hierarchyid types) . This might be out of date CLR types or a 32/64 bit mismatch. The log file provided shows you're running FME 32bit so ensure you're installed SQL Server CLR Types are also 32bit. Or try using FME 64bit (you'll have to ensure you have Esri 64bit Geoprocessing installed - see this article)