 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
niezgod
Joined: 29 Jun 2011 Posts: 5 Country: Poland |
|
[SA 6 Beta] Repository Browser - add DB to workspace |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
We are looking into that.
What do you mean by "except procedures who overwraps assemblys methods?"
|
|
Fri Jul 01, 2011 7:57 am |
|
 |
niezgod
Joined: 29 Jun 2011 Posts: 5 Country: Poland |
|
|
|
 |
 |
...
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|