Red Gate forums: SQL Doc 2

RE: Does SQL Doc 2 have any extended cli switches?

james.billings — Wed, 15 May 2013 10:46:48 GMT

Our bugtracker isn't externally facing I'm afraid so there's no way for you to easily track this yourself. Feel free to enquire directly with us if you do want an update though.

RE: Does SQL Doc 2 have any extended cli switches?

JJB7 — Wed, 15 May 2013 08:35:29 GMT

james.billings wrote:

ref. SDOC-1428

Thanks for confirmation James, where would I find this?

RE: Does SQL Doc 2 have any extended cli switches?

james.billings — Tue, 14 May 2013 19:11:01 GMT

Currently, I think you're stuck with the options given. When you run

SQLDoc.exe /? /v

The output is generated directly from the executable based on the arguments it would accept internally (i.e. it's not some text we're squirting out and there are extra secret options)

We already have a similar request logged (ref. SDOC-1428) so I will add a link back to this forum post to that request as a "+1".

Does SQL Doc 2 have any extended cli switches?

JJB7 — Mon, 13 May 2013 16:35:52 GMT

Is SQL Doc bound to a project? Are you able to use switches with SQL Doc like you can with SQL compare? Scenario I'm interested in is the ability to check / un-check batches of objects dynamically through switches (i.e. to exclude a specific schema). Say I wanted to exclude all procs on the "import" schema, I'd need to open the project, untick all the procs, then re-save and re-run.

Related to that, the behaviour (which I've read on a forum post, not tested admittedly...see here) whereby newly created objects would be added to the project automatically is not the behaviour I'd want if I can't specify which schemas I want to include? Suppose I exclude everything on a schema called "build" so as not to expose it to the end user, if a new object is added does that mean it gets included?

RE: No Used By Information in Generated Documentation

james.billings — Tue, 09 Apr 2013 19:49:39 GMT

Thanks for your post.

I've tested this and it seems to work OK for me.

Could you be a bit more specific about the kind of 'uses' that aren't working? Are you including all objects in the output? Have you got enough permissions to the database?

No Used By Information in Generated Documentation

jgelinas3333 — Mon, 08 Apr 2013 16:11:31 GMT

The preview indicates that Uses and Used By will appear in the generated documentation. It does not. Any reason why?

RE: Display of single quotes in documentation

stanori — Fri, 29 Mar 2013 14:32:43 GMT

Hi tbussmann,

Thanks for your post. The issue you are describing has been reported as a defect under SDOC-1507. We do not yet have a timeframe of when this might be addressed. If anything changes, I will get in contact with you.

Best Regards,
Steve

Display of single quotes in documentation

tbussmann — Thu, 28 Mar 2013 05:36:47 GMT

I noticed that when I use a single quote (') in a column description, SQL Doc displays the description with a two single quotes ('') after doing a refresh or coming back to my project later. I realize that it needs to use the escape quote to properly store the description in the database, but could you make it so that it only displays the one single quote (') in the UI and generated documentation?

Thanks.

Object reference not set to an instance of an object

maximves — Wed, 27 Mar 2013 12:50:39 GMT

Hello,
We have purchased sql doc license, and have encountered "Object reference not set to an instance of an object" problem. Stack trace in the log:

Code:

System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SQLCompare.Engine.ExtendedPropertyValue.ToString()
at „.„.�š()
at „.„.š™()
at „.„.“™()
at „.„.Œ()
at †.†.�(€ )
at ž„.‘†.š(€ )
at ž„.‘†.š(IList`1 )
at ž„.‘†.š(€[] )
at ž„.�„.š(€[] )
at ž„.�„.›‡(€[] )
at †.†.�(€ )
at †.†.�(€ )
at †.††.ž(ProgressPercentageTracker , † , € , Int32 )
at †.††.ž(ProgressPercentageTracker , † , € , Int32 )
at †.††.ž(ProgressPercentageTracker , † , € , Int32 )
at †.††.ž(ProgressPercentageTracker , † , € , Int32 )
at †.††.�(ProgressPercentageTracker , ›�’ , € )
at “†.‡.™(ProgressPercentageTracker )
at “†.‡.—(ProgressPercentageTracker )
at “†.‡.–(String )

I have removed all the extended properties from the table that caused sqldoc to fail, but it still fails on the same table. I even have recreated the project, but I get the same error. sqldoc version 2.1.2.1

RE: Scheduled Task Action Parameter To Overwrite Existing Files

Manfred.Castro — Thu, 07 Mar 2013 20:46:39 GMT

You can use the /force switch
/force (Alias: /f)
Forces overwrite of any files written.

Scheduled Task Action Parameter To Overwrite Existing Files

joshOrbit — Wed, 06 Mar 2013 18:56:34 GMT

The windows scheduled task runs and writes the files the first time, after that the task runs but the files are not actually updated.

Is there a parameter I can add to tell it to overwrite the existing files?

Thank you!

RE: Add link in *.chm file

kimpenhaus — Wed, 06 Mar 2013 13:55:11 GMT

Same here - not that I wish to use a link (in anchor form) for generated *.chm files but I'd like to have rule for creating links inside documentation (wiki-like) where I can reference different tables / columns from within my documentation of specific objects.

RE: Need a possibility to change Extended Properties ...

fargs — Thu, 28 Feb 2013 19:40:28 GMT

It looks like this has been requested and tracked for a very long time (SDOC-775). I am updated to the latest version of SQL Doc and it is still not implemented. Is this going to happen? It would be a very useful feature. It doesn't necessarily have to be in SQL Doc. It could be a plug in to SSMS. I am currently using this for free.

http://datadictionary.codeplex.com/

Thanks,

RE: Permissions showing members of roles

Manfred.Castro — Thu, 21 Feb 2013 19:15:59 GMT

Unfortunately this is not currently possible.
There is an existing feature request for greater control over the documentation generated under the internal refernce number of SDOC-1431.
I have added your request to the existing request

Permissions showing members of roles

PCurd — Wed, 20 Feb 2013 16:43:11 GMT

Is it possible to get SQL Doc to show the members of database roles when listing Permissions so I don't have to go and check the roles individually? This is especially important when developers etc check the documents as they don't have access to the role members.

Same question for accounts or roles mapped to Active Directory groups.

Thanks,