SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 6 Beta] Repository Browser - add DB to workspace

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 6 Beta] Repository Browser - add DB to workspace
Author Message
niezgod



Joined: 29 Jun 2011
Posts: 5
Country: Poland

Post [SA 6 Beta] Repository Browser - add DB to workspace Reply with quote
I try to add database to new SVN workspace. Connect to new SVN repository, select and expand database on databases tree in Repository Browser.
Running command "update Workspace from Database" directly on whole database finishes with creating database folder and empty object types subfolders in workspace -maybe OK.

Adding ( command "Update Workspace from Database") all procedures and views finished with success (except procedures who overwraps assemblys methods). Adding tables finishes with adding one or two tables and exception occurs (sent separately by error reporting mechanism). Adding tables manually one by one works OK.

Adding user functions was identical as tables. Additionally Repository browser "shows" only Table-valued Functions (first subcategory in user functions in SQL server) and ignore Scalar-valued and Aggregated functions.


Am I doing something wrong?

Widnows XP prof., Microsoft SQL server 2005 developer edition.
Fri Jul 01, 2011 4:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
We are looking into that.

What do you mean by "except procedures who overwraps assemblys methods?"
Fri Jul 01, 2011 7:57 am View user's profile Send private message
niezgod



Joined: 29 Jun 2011
Posts: 5
Country: Poland

Post Reply with quote
SysOp wrote:
...
What do you mean by "except procedures who overwraps assemblys methods?"


Procedures whose has not own code and only reference to methods in CLR assemblies.

CREATE PROCEDURE procname
...
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [assembly_name].[class_name].[method_name]

Such procedures are not editable so probably this is not bug they are ignored by Repository Browser. This will be perfect situation to be available to store every object type in repository ;)
Fri Jul 01, 2011 8:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Hi. At the moment assemblies aren't supported. I've logged case for the other issue #SA0014803 with scalar and aggregate functions
Fri Jul 01, 2011 12:04 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.