I am trying to generate the database scripts(tables,triggers,views,procedures) in sql server 2008, all of sudden the scriptting wizards hang up at the end state saying that scripting is completed but the close button never enable, if i stop this some of the tablels are missing, please advise
-
It looks like there may be a couple of issues with that feature, have you installed the latest servicepack? And have you tried generating the scripts in some other way (e.g. with SMO or a third-party tool)?Pondlife– Pondlife2013-05-17 14:51:08 +00:00Commented May 17, 2013 at 14:51
-
1Run the profiler while scripting. You should get an idea of where it is hanging at least. There could be all kinds of reasons really.RThomas– RThomas2013-05-17 15:07:49 +00:00Commented May 17, 2013 at 15:07
-
I am using script wizard, it will hangs abruptly some times hence some times works perfectly, not sure where is the mistake.user2393951– user23939512013-05-21 07:31:49 +00:00Commented May 21, 2013 at 7:31
Add a comment
|
2 Answers
Install earlier SSMS version. For me bug was at 15.0.18358.0, changed to 15.0.18338.0 and the wizard started working.
Comments
If the wizard says "0 Remaining", this means it has determined all the objects that it needs to script, and is writing them out to your destination. If you are writing to a file, go to that file location in Windows Explorer, and keep refreshing the view. If the file keeps growing in size, this means everything is fine and the data is still being written. Be patient, and eventually the process will finish and the Close button will become enabled.
Comments
