SSMS Generate scripts
SSMS generate scripts dialog tries to generate, but hanges forever in the latest version of SSMS 18.7.1.
This has been fixed in the latest release of SSMS, 18.8.
Bug still exists on 18.8 and 18.9.1.Verified!
Generating Scripts does not work any more since last update 18.7.1
While you are at it, can you please fix "Msg 13908 Cannot access internal graph column 'from_obj_id_xxxxx' ? I know Graph Db is still a bit a stepchild but the basic script generation should be supported (here I tried to create a non-clustered index via SSMS script on an edge table.
Confirmed, same issue here with 18.7.1. Tried reinstall + removed all configuration files. Didn't help.
Older versions still work, so it's probably a newly introduced bug..
Leif Powers commented
In SSMS 18.6.1, right click on the database, "Generate Scripts" hangs, but only with certain databases. 18.5 and earlier do not have this issue. Not sure the data to provide to help troubleshoot.
Mark Panarusky commented
Times out on Choose Objects form. Error message in XML: The Visual Studio component cache is out of date (assembly: Microsoft.VisualStudio.Platform.VSEditor, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a). Clearing temp files does not fix.
I opened this too, had 17.9.1 loaded on the same machine and it works no problem. Had to revert to build deployment scripts for my application.
We are running Microsoft SQL Server 2014 (SP3-CU4) (KB4500181) - 12.0.6329.1 (X64) Jul 20 2019 21:42:29 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Hangs on Choose objects section. Loaded old version 17.9.1 and it works no problem and loads this screen in a couple of seconds. On 18.7.1, I let it hang for 30 minutes and tried multiple times.
Leo Kuneman commented
Using the Generate Scripts Wizard, you get no response when getting the database objects. The Wizard just remains on Please wait while trying to access the database objects. Thought it was a GoDaddy issue. They duplicated the problem, but could not find out why. I uninstalled 18.7.1 and reinstalled 18.6 and the issue went away.
Frank J commented
Hangs on Choose objects. How to rollback a version?
Chris Marlow commented
18.7.1 Also seeing hang on scripting 2014 databases
Paul Dixon commented
SSMS 18 7 1 does not script sql 2012 databases, it hangs on the loading database information page.
It does work on SQL 2017, but I need SQL 2012 as well.
Same here, it hangs in Generate Scripts window on Choose Objects
Jarmo Poolak commented
It hangs at the 'Choose Objects' screen where it tries to load database information. Previous version worked. For me this is a blocking issue.