StrataFrame Forum

Updating table with identity field

http://forum.strataframe.net/Topic8589.aspx

By softaca - 4/30/2007

Hi,

In the process of migrating my database update systeem to the strataframe system, i've made several definition errors. A few of them were PK fields with identity specification where there should not be a identity specification. So i made the corrections in the DDT and generated a new deployment package. When i applied the package to my test server i found out that the identity specification stills exsist!!! Is this a bug or do i do something wrong?

By Trent L. Taylor - 4/30/2007

This is already a known issue and is slated to be in the next update.  The problem is that you are trying to make an existing field have an identity after it has already been created.  If the table was deployed clean the first time it would work.  This is already known and a fix is in the works.  To work around, you can open up the SQL Management Studio and set the identity on the database that already exists.
By softaca - 4/30/2007

Thanks for the very quick reply. I already applied the workaround as you mentioned but thought to mention it anyhow, because if this happended in a life situation the problem would have been bigger. Any idea when the fix will be available?
By Trent L. Taylor - 4/30/2007

We are hoping to have it included in the 1.6.1 update.