| Author |
Message |
karen
Joined: 25 Aug 2010
Posts: 7
|
 Posted: Tue Aug 31, 2010 5:42 pm Post subject: Does SQL Doc 1.3 work against SQL Server 10.0? |
 |
|
I'm trying to document a database, and when I select the checkbox, it doesn't expand. When I run the doc, it just gives me an overview of the database itself, but doesn't document tables, views, etc. I am dbo in the database.
I have SQL Doc 1.3.0.596 and the database is SQL-Server 10.0.2531 |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Wed Sep 01, 2010 6:11 pm Post subject: |
|
|
I have just run this on my test system (SQL Doc v1.3.0.596 & SQL Server v10.0.2531) and it works absolutely fine. There is only a problem with running SQL Doc against SQL Server 2008 R2 for which there is a cumulative patch in the SQL Doc v2 forum.
Last edited by chriskelly on Thu Sep 02, 2010 11:42 am; edited 1 time in total |
|
| Back to top |
|
|
karen
Joined: 25 Aug 2010
Posts: 7
|
| Posted: Wed Sep 01, 2010 10:59 pm Post subject: |
|
|
| Will the cumulative patch work for this old SQL Doc too? It wasn't clear in the other forum. |
|
| Back to top |
|
|
karen
Joined: 25 Aug 2010
Posts: 7
|
| Posted: Wed Sep 01, 2010 11:24 pm Post subject: |
|
|
I am DBO on the particular database I am trying to document, it is SQL 2008 (not 2008 R2). And the tree won't expand to show the tables, views, procedures.
When I document anyway, choosing the box that implis the entire database, it returns one page, that says "•You have not chosen to document any objects in this database" |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Thu Sep 02, 2010 11:58 am Post subject: |
|
|
With some further testing, I have found that using Database Encryption e.g. TDE will prevent SQL Doc from being able to open the objects. If this is the case, try turning off the encryption.
If however, I am wrong can you send to support@red-gate.com some material so that I run some further tests. A script so that I can create your schema would be ideal (no need to send any data). A copy of the Documentation that you have generated would also be useful for comparison. Please mark in the subject header as being for my attention. |
|
| Back to top |
|
|
karen
Joined: 25 Aug 2010
Posts: 7
|
| Posted: Thu Sep 09, 2010 7:16 pm Post subject: |
|
|
| I am checking with our DBAs to find out if it is encrypted. |
|
| Back to top |
|
|
karen
Joined: 25 Aug 2010
Posts: 7
|
| Posted: Wed Sep 15, 2010 9:05 pm Post subject: |
|
|
| The database is not encrypted, so I don't know why it will not document. However, one of our DBAs has SQL Doc 2, so I will just have him document databases when my old version has issues. (It might be time to get them to buy me an upgrade too!) |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Mon Sep 20, 2010 2:39 pm Post subject: |
|
|
| Have you been able to document your database using SQL Doc 2, as you mentioned you would try in your previous post? |
|
| Back to top |
|
|
frisky
Joined: 02 Mar 2012
Posts: 2
|
| Posted: Fri Mar 02, 2012 12:54 pm Post subject: Re: |
|
|
| chrisk5 wrote: |
With some further testing, I have found that using Database Encryption e.g. TDE will prevent SQL Doc from being able to open the objects. If this is the case, try turning off the encryption.
|
To the point. The reason lies in this. After turning off the encryption, everything started to work fine. I have I have cell phone spy software SQL Doc 1.3.0.596. |
|
| Back to top |
|
|
|
