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?
Userlevel 4
- 8177 replies
-
8 May 2018
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?
Userlevel 4
+13
- Contributor
- 3725 replies
-
9 May 2018
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?
+2
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)
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.