Red Gate forums :: View topic - History of changes?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

History of changes?

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
laurencerooks



Joined: 29 May 2007
Posts: 21

PostPosted: Fri Jun 22, 2007 9:12 pm    Post subject: History of changes? Reply with quote

How do you either enable or view the history of changes in a sql object documented with SQL Doc? I am using a trial of SQL Doc 1 v1.2.0.29. I have documented my server, which won't allow me to change the name from local to the name of the server. I have made a change to a stored procedure within one of the databases documented. I have run SQL Doc again to document the server by using the following command line:

"C:\Program Files\Red Gate\SQL Doc 1\SQLDoc" /project:C:\Inetpub\wwwroot\TXXPW204\TXXPW204.sqldoc /force /verbose

I see the new stored procedure, but I don't see anything that tells me it is a new version. I'm trying to demo this to my boss as an alternative or compliment to the source control we currently are using. Does anyone have any ides or suggestions as to why I'm not seeing a history?

Laurence
Back to top
View user's profile Send private message
david connell



Joined: 21 Nov 2005
Posts: 207

PostPosted: Tue Jun 26, 2007 11:20 am    Post subject: Reply with quote

Hi Laurence,
Please explain further
Quote:
which won't allow me to change the name from local to the name of the server.

Currently SQL Doc does not show a history of changes to a sql object. SQL Doc is designed to compliment source control and not replace it.
Have you checked out SQL Compare 6.0, it now supports comparing by scripts. This may help you in storing your schema in source contol.
Hope that helps
Best regards
David Connell
Back to top
View user's profile Send private message
laurencerooks



Joined: 29 May 2007
Posts: 21

PostPosted: Tue Jun 26, 2007 2:33 pm    Post subject: Reply with quote

1. When I launch the application, it automatically defaults to local as the name of the SQL Server located on my workstation. The name is greyed out and doesn't allow me to change it to the actual name of the instance, which would be TXXPW204 in this case.

2. Your data sheet on SQL Doc says the following:

"When should I use SQL Doc?
SQL Doc is a simple tool designed to document and export database schemas into HTML for many different tasks: a
history of changes, QA purposes, dependency analysis and reporting."

I'm not looking for it to replace my current source control. I'm looking for a way to display what I currently have within my source control. Per the PDF data sheet, we should be able to do that.

Laurence
Back to top
View user's profile Send private message
david connell



Joined: 21 Nov 2005
Posts: 207

PostPosted: Tue Jun 26, 2007 2:49 pm    Post subject: Reply with quote

Hi Laurence
SQL Doc by default opens the last project created. You can turn off this feature by going to Options from the Tool menu and unchecking "Open most recently used project on startup". If you create a new project you should be able to select a different SQL Server instance. I don't think SQL Doc allows you to change your server instance, only your authentication.

I think that SQL Doc will only display what is available in the SQL Server Database, it does not link into your Source Control system.
Hope that helps
David
Back to top
View user's profile Send private message
Nick Warren



Joined: 16 Apr 2007
Posts: 3
Location: Cambridge, UK

PostPosted: Tue Jun 26, 2007 3:09 pm    Post subject: Reply with quote

Laurence - I've reviewed the content of the data sheet with respect to the 'history of changes' and agree that it's particularly unclear. It alludes to the benefit of using SQL Doc to create historic snapshots of your database that can be visually compared to understand the history of changes to an object - it cannot display a list of changes to a database object since this information is not stored within SQL Server. In a future release we could possibly identify objects that are new or have been modified since the last SQL Doc snapshot.

It may be useful for you to look at the features offered by SQL Compare/Data Compare since these do offer a view of changes between two database versions?

In the meantime, I will ask our marketing team to review this wording to improve clarity!!
_________________
Nick Warren
Head of Customer Support
Red Gate Software

e: nick.warren@red-gate.com
t: +44 (0)870 160 0037
w: www.red-gate.com
Back to top
View user's profile Send private message Send e-mail
laurencerooks



Joined: 29 May 2007
Posts: 21

PostPosted: Tue Jun 26, 2007 3:11 pm    Post subject: Reply with quote

Thank you Nick. Just for clarity, I wasn't trying to find a replacement for our source control. I was trying to find a way to display it via a web interface so that my boss or anyone else who is interested doesn't have to have the source control software installed. I figured this would be able to do that.

Laurence
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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