Toad World® Forums

FW: CaseID:928346 - Toad-SS Object Explorer - User Define Tables Tab

To: Toad-ss user community à FYI !!!

Something to comment on, where appropriate !

Respectfully !!!

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

Hiu, Valentine and Alex.

I am going to be using extended properties as you can see in the example below,
where I have made and entry for the Primary Key of a new table CIS.BtuFactor.

What is going on here is as a DBA/Data Architect,

I am migrating DB2 mainframe databases, data table and columns names. Ax an
example the DB2 table CIS_BTU_FACTOR à becomes SS-2008 CIS.BtuFactor for the
tables and

KY_BTU_NO to PK_BtuFactor as an example.

I am using this script to add a comment.

use [GCMA_STAGE]

go

EXEC [sys] . [sp_addextendedproperty]

@name = N'MS_Description'

, @value = N' Orig: CIS BTU_FACTOR.SS2008:PK_KyBtuNo for CIS.BtuFactor records.
'

, @level0type = N'SCHEMA' , @level0name = N'CIS' , @level1type = N'TABLE'

, @level1name = N'BtuFactor' , @level2type = N'COLUMN' , @level2name =
N'PK_BtuNo' ;

GO

WHAT IS Needed in Object Explorer is more functionality in displaying database,
schema, table extended properties. Currently Object Explorer is doing a great
job showing the column extended property as a comment, which should be labled
MS_Description. In the below example I am showing the prior DB2 name in the
comment and this will aid those developing / migrating any applications from the
DB2 system to the SQL Server system.

There4 : What I want to know is can the whole subject matter of what should be
in Object Explorer be opened up a bit especially in regards to Extended
Properties?

I personally like extended properties for the data element comment capabilities,
but there is so much more that is done at the table and database level that if
done right would be a real asset to Toad-SS users worldwide.

Please give this some serious thought and either incorporate what I am asking
here into CaseID 928346 or please make a new CaseID, from this email

Respectfully !!!

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

image001.jpeg

image001.gif


image001.jpeg

I agree - extended properties deserve more attention. something to consider for upcoming release. Thanks for sharing!