Need Data Compare to dump Table & View results to excel
DBATrollman
Posts: 11 Bronze 5
New to Data Compare Tool.
We are trying to upgrade a third party Vendor database to the latest version but we have lots of code based on the table, view, stored procedures, and functions in the old version and want to be sure that all that still exists in upgraded version.
When reviewing Tables & Views in the The Data Compare tool (version 12) we can see some missing tables, new tables, and column changes in older tables. We need to be able to pull this report out to be able to review all the changes but I do not see an option for looking at this in an xml or excel (xlsx) format? We have to be able to document and html and pdf formats do not work easily to accomplish this.
I would hate to have to manually go through your page re-typing this information so I can pass it to the development team to review and document.
Thanks,
Tim
@DBATrollman
We are trying to upgrade a third party Vendor database to the latest version but we have lots of code based on the table, view, stored procedures, and functions in the old version and want to be sure that all that still exists in upgraded version.
When reviewing Tables & Views in the The Data Compare tool (version 12) we can see some missing tables, new tables, and column changes in older tables. We need to be able to pull this report out to be able to review all the changes but I do not see an option for looking at this in an xml or excel (xlsx) format? We have to be able to document and html and pdf formats do not work easily to accomplish this.
I would hate to have to manually go through your page re-typing this information so I can pass it to the development team to review and document.
Thanks,
Tim
@DBATrollman
Comments
Another possibility would be to use SQL Doc to generate documentation for an individual database.
Redgate Software
To have to take the HTML report, take a screen snapshot of the change, mark it and send to to a developer to check his code is a ton of work on a database with 277 table changes. Almost as bad as having to type a copy of the information that is sitting right in front of me on the screen from the Data Compare table and Views tab. Very frustrating. Glad I have some place to vent!