Help doc current schema as well as Migration Script.

kwsmith

Please add an option to allow us to right mouse click a line in the comparison page to save both sides to two different files (one for each side). Also give us the option to click a range of lines and all the scripts for each side would get saved to 1 large file. It would be nice to document current schema as well as document the migration script for each side. I have to document the current db as how it is different from another DB prior to backing it up and removing it. I don't want to merge, but I do want to document prior to recovering the DB over the other copy.

David Atkinson

If you need a document describing the differences, have you considered simply saving the html report? Generate Comparison Results Report is found under the Tools menu.

David Atkinson
Red Gate Software

kwsmith

I am also looking to document what is currently the script for the view, table, stored procedure, etc. for each database being compared. I want to document what is currenly in place before I use SQL Compare generated migrate scripts to modify the DB, in case I have to undo the migration. This is particularly true for Stored Procedures and triggers.

David Atkinson

Have you looked at SQL Doc?

http://www.red-gate.com/products/sql-de ... t/sql-doc/

David