Identity Column

Oct 24, 2010 at 1:10 AM


I am using v3.6.0.173 with VS2008.

I had some SQL tables with Identity Speification:(Is Identity) set to 'No'.  I looked in my WSGEN and noticed that Identity was set to 'None'.  So I set it to 'Database' and run an update to SQL server.  However, this did not update my SQL Speification:(Is Identity) to 'Yes' so I did it manually.  Is this by design ?

I double checked before posting this.



Oct 26, 2010 at 6:46 AM

This type of change is currently not part of our automatic upgrade script. If you need to perform this as part of the upgrade you will need to added it to the upgrade script file generated for the version. This is by design. Mainly because a change of this type would typically require additional scripting to handle fixing existing data in the database.