× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2013-10-07T09:13:03Z  · last modified 2017-01-03T11:20:03Z

Extended properties not include in compare script.


Dev ajinkya(*)
QA
Ivan Gron
ivangron
Priority Low
Complexity Unknown
Component Tools - Compare
Version 18.0
Database version: Ms sql server 2005 
ADS version : ads-windows-x64-14.0-rc-44
 
Connect Ms sql server 2005
Create two tables with extended properties in different schema.
 
CREATE TABLE [Admin].[Table_ex_pro]  ( 
[col1] bigint NULL,
[col2] varchar(25) NULL,
[col3] varchar(25) NULL 
)
GO
EXEC sp_addextendedproperty 
@name = N'MS_Description', @value = N'Coment made on Oct 7 2013', 
@level0type = N'Schema', @level0name = N'Admin', 
@level1type = N'Table', @level1name = N'Table_ex_pro'
 
 
CREATE TABLE [dbo].[Table_ex_pro]  ( 
[col1] bigint NULL,
[col2] varchar(25) NULL,
[col3] varchar(25) NULL 
)
GO
EXEC sp_addextendedproperty 
@name = N'MS_Description', @value = N'Coment made on Oct 4 2013', 
@level0type = N'Schema', @level0name = N'dbo', 
@level1type = N'Table', @level1name = N'Table_ex_pro'
 
 
Go to tools menu bar->select Compare tools->select schema compare->choose server->Select 'Admin' and 'dbo' schema from schema drop- 
down list->check tables from object type->check tables from objects->check include comment option->click compare button.->click on table.
 
Now you will observe that extended properties not include in compare script.
5 attachments
  •  
  •  
  • No shares
  •  
All Comments (5) Change History
Sort 

Issue #10339
Closed
Fixed
Resolved 2016-09-27T15:44:12Z
 
 
Completion
No due date
Fixed Build ADS v-18 devi-243
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017