New answers tagged scripting
Try www.sqlscripter.com It supports INSERT statements as well as UPDATE etc., so you can do something like this: IF NOT EXISTS (...) INSERT ... ELSE UPDATE ... It works for us so it may work for you.
The spatial index, as with other objects, have their own script <object> as menus and need to be done separately. This can be done to the clipboard and pasted to the query window generated by the script table as command. I can't confirm at the moment, but I suspect that the primary key and other constraints come out in the script table as options ...
Top 50 recent answers are included