Red Gate forums :: View topic - Documenting from sql compare snapshot
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

Documenting from sql compare snapshot

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



Joined: 29 Nov 2007
Posts: 21

PostPosted: Mon Jan 07, 2008 6:04 pm    Post subject: Documenting from sql compare snapshot Reply with quote

Is there any way to use sql doc to document a sql compare snapshot in an automated fashion? What we're trying to do is to automate the documentation of differences so that when someone comes up to our desk and says "did anything change in the last three days to the db" we can just send them the file in the great HTML format that sql doc has.

We are thinking of doing the following:

1. Have sql compare create a snapshot of the db off hours automatically
2. Have sql doc create a diff doc based off the snapshot automatically (could be during the day).

Some related questions:

1. Can sql doc generate documentation based on a sql compare snapshot and not just a live db?
2. Can we use the sql toolkit to automate the sql doc without having to create a project first?
3. If we can't use sql doc, how could we create an automated diff report in sql compare?

Thanks in advance!
Laura
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Mon Jan 07, 2008 8:47 pm    Post subject: Reply with quote

Sadly, SQL Doc will only run on a live Database, so unless you redeploy your database from the snapshot using the SQL Compare command line, you won't be able to do this.

Have you considered simply using the SQL Compare commandline to compare the two snapshots? The /snapshot: switch can load the snapshot and the /report: switch generates a report. /reporttype:Simple will produce a simple HTML report. /reporttype:Interactive outputs the interactive HTML report.

Use:
sqlcompare.exe /? /v /html > help.htm to generate a commandline html file in which all the various options are described.

You should be able to write a short batch file to generate this report only when the comparison reveals a difference (the %ERRORLEVEL% exit code will be 63 when the databases are identical).

Red Gate Scream (http://labs.red-gate.com/index.php/Red_Gate_Scream) is a handy, free UI-based tool that allows you to compare two snapshots.

Hope this helps,

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
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