# Schema Compare Reporting (Version 7.0.3.37 64-bit) **URL:** \ **Category:** Toad for SQL Server\ **Created:** [March 24, 2020, 1:00am UTC](https://forums.toadworld.com/t/schema-compare-reporting-version-7-0-3-37-64-bit/49390 "2020-03-24T01:00:41Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![tom.wickerath](https://avatars.discourse-cdn.com/v4/letter/t/bb73d2/32.png) [@tom.wickerath](https://forums.toadworld.com/u/tom.wickerath)\ **Post date:** [March 24, 2020, 1:00am UTC](https://forums.toadworld.com/t/schema-compare-reporting-version-7-0-3-37-64-bit/49390/1 "2020-03-24T01:00:41Z")
There must be an easy way to produce a report showing differences only, when comparing two databases, but it is not obvious to me. I just did a comparison of our TEST and Production databases. I'm seeing a lot of differences, but when I generate the report, it is only showing the object names with differences, not what is different. I'd like a report that shows the required ALTER scripts in TEST, to make our TEST the same as Production. ---
**Author:** ![VasiliyFofanov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vasiliyfofanov/32/10873_2.png) [@VasiliyFofanov](https://forums.toadworld.com/u/VasiliyFofanov)\ **Post date:** [March 24, 2020, 1:44pm UTC](https://forums.toadworld.com/t/schema-compare-reporting-version-7-0-3-37-64-bit/49390/2 "2020-03-24T13:44:37Z")
Hello Tom, You can select option 'Detail Report' in Schema Compare Report Wizard. In the same page you can select only non equal objects\properties that you want to see ![image](https://global.discourse-cdn.com/quest/original/2X/a/a7d641675f8aa2091e62a0696a4eafa8d6964622.png) Alter scripts only available in synchronization script. You can generate sync script and open it in Editor without run immediately ---
**Author:** ![tom.wickerath](https://avatars.discourse-cdn.com/v4/letter/t/bb73d2/32.png) [@tom.wickerath](https://forums.toadworld.com/u/tom.wickerath)\ **Post date:** [March 28, 2020, 4:44am UTC](https://forums.toadworld.com/t/schema-compare-reporting-version-7-0-3-37-64-bit/49390/3 "2020-03-28T04:44:33Z")
Hi Vasiliy, Sorry for the late reply. What did you click on to display the screen you have shown? I cannot find Waldo! It really shouldn’t be this difficult, but this is likely a PEBCAC Error! J After I complete a Schema Comparison, I see the following screen. In this example, the Production database is the Source, and a TEST database is the Target: ![image003.png](https://global.discourse-cdn.com/quest/original/2X/a/a1590b85a2f59ad23f87805664e37a79f3990490.png) My goal is to make the Test schema the same as our current Production schema. The next screen I see is shown below: ![image006.png](https://global.discourse-cdn.com/quest/original/2X/4/4c04a0c48b17f8d33bb89a459caa7221b30fb9c4.png) If I click on Tools \> Reports \> Schema Reports…. ![image008.png](https://global.discourse-cdn.com/quest/original/2X/2/2b0b2d199c01bfa3780a11f652a5d4b1c2adfd21.png) …. I see a screen that looks pretty blank. It includes (3) toolbar buttons. The left-most button looks promising—the ToolTip reads “Generate Report”, but when I click on it, nothing happens! ![image012.png](https://global.discourse-cdn.com/quest/original/2X/a/a24f41eb8cabaa7958eb6d4dc2d9e04e82bbb8d7.png) And, in the process of preparing this reply, I _think_ I finally found elusive Waldo! One has to click on the indicated toolbar button, in the same window I saw in Step 2, above. ![image019.png](https://global.discourse-cdn.com/quest/original/2X/b/b5487439be1bf9b9962f87eac42f9821394450fd.png) This is not very discoverable, to have to hover one’s mouse over various toolbar buttons. Anyway, I clicked on the above toolbar button. It generates a 75 page report, but then the process seems to freeze before it is finished. The progress seems to have stopped on a Preview phase, stuck here for over 5 minutes: ![image020.png](https://global.discourse-cdn.com/quest/original/2X/c/ce6950867b5f07c299fbda9f880c50a11f637a4a.png) I had to eventually kill this task in TaskMgr: ![image021.png](https://global.discourse-cdn.com/quest/original/2X/8/8efb1df4cd0f4fd5dc6037a6b304eb0408d87987.png) Tom ---
**Author:** ![VasiliyFofanov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vasiliyfofanov/32/10873_2.png) [@VasiliyFofanov](https://forums.toadworld.com/u/VasiliyFofanov)\ **Post date:** [March 31, 2020, 6:13pm UTC](https://forums.toadworld.com/t/schema-compare-reporting-version-7-0-3-37-64-bit/49390/4 "2020-03-31T18:13:13Z")
Hi Tom, We will recheck report generation to reproduce your case. If your goal is to make the Test like Production just run generation of synchronization script. ![image](https://global.discourse-cdn.com/quest/original/2X/a/ac113b12eb234579db5ccbf3594ce3a277419d29.png) You can generate script and run it later after review ![image](https://global.discourse-cdn.com/quest/original/2X/0/03b8821b2caa9e4dddbd2ca915038ce028e6bef0.png) You can review script in Toad editor with Script Map for easy navigate ![image](https://global.discourse-cdn.com/quest/original/2X/f/fde2065d1d95ff6f9ff1e578a6074f2b93e89ff3.png) I hope it help ---
**Author:** ![tom.wickerath](https://avatars.discourse-cdn.com/v4/letter/t/bb73d2/32.png) [@tom.wickerath](https://forums.toadworld.com/u/tom.wickerath)\ **Post date:** [March 31, 2020, 9:26pm UTC](https://forums.toadworld.com/t/schema-compare-reporting-version-7-0-3-37-64-bit/49390/5 "2020-03-31T21:26:02Z")
I can try running the synchronization script, however, I have discovered that certain objects in our TEST database have useful comments that are not present in the Production copy. So, I need to be very careful about a wholesale replacement of PROD à Test. Are there any log files available, that I might be able to send, that would be helpful to help determine why the process seems to freeze on me? Thanks, Tom