Studio 2012 - Generate Scripts with data Cut Off - by AMDH

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 795651 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/1/2013 3:01:08 AM
Access Restriction Public


When I select "Generate Scripts" in tasks menu of the Studio 2012 and set the options so that both table creation and insert data is selected and create a file per object. You will see that in this mode the scripts are generated in separate threads per object. This differs from the Studio 2008 R2. However, many of the generated scripts are cut off, incomplete. I would say that 75% of the scripts are complete, and 25% incomplete or even totally empty. It looks like the generation processes are stopped before all are complete. I saw this phenomenon on 2 different machines, once on a server, once on my notebook. For now I have resorted to re-installing the Studio 2008R2 which works a lot slower, but generates the correct scripts.
This  happened on a Notebook with Win7Pro 32-bit (English)
And a server with Windows Server 2008R2 64-bit (German)
Sign in to post a comment.
Posted by Microsoft on 8/2/2013 at 9:57 AM
Hello AMDH. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you.

-Walter A Jokiel, Program Manager, SQL Server (