Hello community,
I'm storing some shapefiles in a MSSQL Server database.
How can I get the SQL script FME used to create the database and populate it from the shapefile ?
Thank you
Question
SQL Script of MSSQLServer tables creation from Shapefile migration
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.
+22- Safer
Hi @lianaolianov, are you wondering what sort of INSERT statement FME is using to write your shapefiles to your SQL Server database?
+5- Contributor
Hi @lianaolianov, are you wondering what sort of INSERT statement FME is using to write your shapefiles to your SQL Server database?
+22- Safer
Hi @lianaolianov, thank you for clarifying your question! You can set up a trace on your database that will show you all of the SQL commands that have been sent to it. It's here that you'll be able to see all of the INSERT statements. This might be something that you'll have to ask your DBA to set up for you.
+5- Contributor
Hi @lianaolianov, thank you for clarifying your question! You can set up a trace on your database that will show you all of the SQL commands that have been sent to it. It's here that you'll be able to see all of the INSERT statements. This might be something that you'll have to ask your DBA to set up for you.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.