Hi,
I am writing to my database (SQL Server Spatial) and would like to in this case, overwrite the automatic sequential numbering system that SQL Server gives each attribute. Any idea how I would go about this?
Question
Writing to Microsoft SQL Server Spatial + Adding my own identity type.
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.
+21- Safer
Hi @torro, are you inserting features or truncating the table? Did you want to drop the sequence and re-create it? If so, you might be able to drop and then create a sequence on the table using the SQL Before/After translation on the SQL Server Writer. Alternatively, you could use an SQLCreator to drop it, then write with a FeatureWriter, and create the sequence again with an SQLExecutor (that is initiated by the FeatureWriter summary feature).