× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2013-10-08T10:08:12Z  · last modified 2017-01-03T11:21:51Z

Extended properties not include in compare script in synonyms .


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 synonym with extended properties.
 
CREATE SYNONYM [guest].[Syno_Exe_Pro]
FOR [dbo].[t1]
GO
EXEC sp_addextendedproperty 
@name = N'Ms_Description', @value = N'comment on 9 oct 2013', 
@level0type = N'Schema', @level0name = N'guest', 
@level1type = N'Synonym', @level1name = N'Syno_Exe_Pro'
GO
 
CREATE SYNONYM [dbo].[Syno_Exe_Pro]
FOR [dbo].[t1]
GO
EXEC sp_addextendedproperty 
@name = N'Ms_Description', @value = N'comment on 8 oct 2013', 
@level0type = N'Schema', @level0name = N'dbo', 
@level1type = N'Synonym', @level1name = N'Syno_Exe_Pro'
GO
 
Go to tools menu bar->select Compare tools->select schema compare->choose server->Select 'guest' and 'dbo' schema from schema drop- 
down list->check synonyms from object type->check synonyms from objects->check include comment option->click compare button.->
click on synonym.
 
Now you will observe that extended properties not include in compare script.
 
3 attachments
  •  
  •  
  • No shares
  •  
All Comments (3) Change History
Sort 

Issue #10357
Closed
Fixed
Resolved 2016-09-28T04:05:23Z
 
 
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