× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2013-10-08T11:10:42Z  · last modified 2017-01-04T11:39:13Z

Extended properties not include in compare script in function.


Dev ajinkya(*)
QA
Ivan Gron
ivangron
Priority Low
Complexity Unknown
Component Tools - Compare
Version Future - .1
Database version: Ms sql server 2005 
ADS version : ads-windows-x64-14.0-rc-44
 
Connect MS_sql_server-2005
Create Function with extended properties.
 
CREATE FUNCTION [Admin].[fun_exe_pro]
(@employeeID int)
returns table
as
return
    select * from [dbo].[Orders]
GO
EXEC sp_addextendedproperty 
@name = N'MS_descrption', @value = N'Comment on 8 oct 2013', 
@level0type = N'Schema', @level0name = N'Admin', 
@level1type = N'Function', @level1name = N'fun_exe_pro'
GO
 
CREATE FUNCTION [dbo].[fun_exe_pro]
(@employeeID int)
returns table
as
return
    select * from [dbo].[Orders]
GO
EXEC sp_addextendedproperty 
@name = N'MS_descrption', @value = N'Comment on 9 oct 2013', 
@level0type = N'Schema', @level0name = N'dbo', 
@level1type = N'Function', @level1name = N'fun_exe_pro'
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 functions from object type->check functions from objects->check include comment option->click compare button.->
click on functions.
 
Now you will observe that extended properties not include in compare script in functions.
 
4 attachments
  •  
  •  
  • No shares
  •  
All Comments (3) Change History
Sort 

Issue #10362
Closed
Fixed
Resolved 2016-09-27T15:51:31Z
 
 
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