DB Builder - Unable to set extended column props

[Colin Nicholls]

Using EA 12, Database Builder. My model is SQL Server 2012, and I want to create a column in a table with extended properties such as AutoNum. However, no matter what data type I use for my column, the Columns extended properties list is empty.

Is this a known problem? How can I make the column properties available to be set for my table columns?

Thanks,

[Colin Nicholls]

This suddenly started working - I think it only works when creating a table for the first time.

I can not go to a previously created table and change the properties of the PK column to be "AutoNum=True".

I've no idea if this is a bug or not...

[Colin Nicholls]

I think I found the root cause. Most of my tables were originally created under an Oracle DB model. I then copied them into SQL Server DB model and changed the "Database" to "SQL Server 2012" (as shown in that YouTube video tutorial).

Unfortunately, it seems as though "DB Version" and "Database" are two distinct attributes, and the existing tables in my SQL Server DB Model have a "DB Version" of "Oracle". (Under the Table Detail tab in Properties).

This means that the extended column attributes are not available for any column in that table object. I have to create the tables from scratch under the SQL Server model.

So the cut-n-paste convenience is really not a viable procedure, at least in Version 12.0.

[Colin Nicholls]

To tie this thread off:

 I've been unable to reproduce the problem using a new project. I haven't managed to identify what i did earlier to encounter the problem. I'm going to chalk this up to "user error/mystery".

Thanks for reading.

[Geert Bellekens]

Hi Colin,

Thanks for your follow up.
Always good if someone ever happens to face the same problem.

Geert