× Heads up!

Aqua Data Studio / nhilam

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

Extended properties not include in compare script in procedures.


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 stored procedure with extended properties.
 
CREATE PROCEDURE [Admin].[ash_proc]
 @LastName nvarchar(50), 
    @FirstName nvarchar(50) 
AS 
    SET NOCOUNT ON;
    select * from  [Ashwini_schema].[crete_constraint]
GO
EXEC sp_addextendedproperty 
@name = N'Ms_description', @value = N'Comment on 8 oct 2013', 
@level0type = N'Schema', @level0name = N'Admin', 
@level1type = N'Procedure', @level1name = N'ash_proc'
GO
 
CREATE PROCEDURE [dbo].[ash_proc]
 @LastName nvarchar(50), 
    @FirstName nvarchar(50) 
AS 
    SET NOCOUNT ON;
    select * from  [Ashwini_schema].[crete_constraint]
GO
EXEC sp_addextendedproperty 
@name = N'Ms_description', @value = N'Comment on 9 oct 2013', 
@level0type = N'Schema', @level0name = N'dbo', 
@level1type = N'Procedure', @level1name = N'ash_proc'
GO
 
 
Go to tools menu bar->select Compare tools->select schema compare->choose server->Select 'Admin' and 'dbo' schema from schema drop- 
down list->check procedures from object type->check procedures from objects->check include comment option->click compare button.->
click on procedure.
 
Now you will observe that extended properties not include in compare script in procedure.
 
4 attachments
  •  
  •  
  • No shares
  •  
All Comments (3) Change History
Sort 

Issue #10358
Closed
Fixed
Resolved 2016-09-28T03:50:36Z
 
 
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