× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2013-10-08T09:16:43Z  · last modified 2017-01-03T11:15:40Z

Extended properties not include in compare script in views.


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 view with extended properties.
 
CREATE VIEW [db_datawriter].[test]
AS 
SELECT * FROM test_exe1
GO
EXEC sp_addextendedproperty 
@name = N'MS_Description', @value = N'comment on 9 oct 2013', 
@level0type = N'Schema', @level0name = N'db_datawriter', 
@level1type = N'View', @level1name = N'test'
GO
 
CREATE VIEW [guest].[test]
AS 
SELECT * FROM test_exe1
GO
EXEC sp_addextendedproperty 
@name = N'MS_Description', @value = N'comment on 8 oct 2013', 
@level0type = N'Schema', @level0name = N'guest', 
@level1type = N'View', @level1name = N'test'
GO
 
Go to tools menu bar->select Compare tools->select schema compare->choose server->Select 'db_datawriter' and 'guest' schema from schema drop- 
down list->check views from object type->check views from objects->check include comment option->click compare button.->click on view.
 
Now you will observe that extended properties not include in compare script.
4 attachments
  •  
  •  
  • No shares
  •  
All Comments (3) Change History
Sort 

Issue #10355
Closed
Fixed
Resolved 2016-09-28T03:59:55Z
 
 
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