Database version: Ms sql server 2005
ADS version : ads-windows-x64-15.0.0-dev-34
Connect Ms sql server 2005
Create table with extended properties
CREATE TABLE "Admin"."A_Test_Exten_prop" (
"Col1" varchar(25) NULL,
"col2" varchar(25) NULL,
"col3" varchar(25) NULL
)
GO
EXEC sp_addextendedproperty
@name = N'MS_description', @value = N'This comment with 14 oct 2013',
@level0type = N'Schema', @level0name = N'Admin',
@level1type = N'Table', @level1name = N'A_Test_Exten_prop',
@level2type = N'Column', @level2name = N'col3'
GO
EXEC sp_addextendedproperty
@name = N'Ms_description', @value = N'This comment with 13 oct 2013',
@level0type = N'Schema', @level0name = N'Admin',
@level1type = N'Table', @level1name = N'A_Test_Exten_prop'
GO
CREATE TABLE "Admin"."A_Test_Exten_prop1" (
"Col1" varchar(25) NULL,
"col2" varchar(25) NULL,
"col3" varchar(25) NULL
)
EXEC sp_addextendedproperty
@name = N'MS_description', @value = N'This comment with 14 oct 2012',
@level0type = N'Schema', @level0name = N'Admin',
@level1type = N'Table', @level1name = N'A_Test_Exten_prop1',
@level2type = N'Column', @level2name = N'col3'
GO
EXEC sp_addextendedproperty
@name = N'Ms_description', @value = N'This comment with 13 oct 2012',
@level0type = N'Schema', @level0name = N'Admin',
@level1type = N'Table', @level1name = N'A_Test_Exten_prop1'
GO
Go to database tree node->Expanded tables node->Select "A_Test_Exten_prop" and "A_Test_Exten_prop1"->Right click on these tables->select compare option
Now you will observe that, Extended properties are missing in compare script.
