X5 Studio crashes when loading large SQL scripts

[roddyvet]

I am running the latest version of X5 Studio and trying to create an MS SQL Script command to execute a script. The script I am trying to load is a little large at 9MB. I am able to use the Load Script file and see the content get pulled into the dialog. When I click Ok, X5 locks up and never responds. I have to kill the process. Smaller scripts load fine. I have the same problem in the Designer and in MSICode.

Is there another way I can call and execute the script?

[bokkie]

I experienced the same effect. I created a text file containing about 10MB-worth of nothing but SQL comments. It took a few seconds to load it in the dialog and clicking the OK button caused my IDE to freeze.

I then reduced the text file by about half its original size and it still froze the IDE. Like you, I eventually found it worked when I got my file down to roughly 1.3MB but at what threshold it eventually breaks I don't have the time to look at. At the other extreme, I tried loading a 150MB file and I got an out of memory exception which is perhaps to be expected.

If we're talking about SQL Server (I don't know the other database engines) I suppose it's possible to keep everything in the file and then use a DOS command to execute the osql command. That can accept an input file on the command line; that's how I remember it anyway but I'll let you investigate that. Then, in theory, you can let the SQL Server engine do the grunt work. It's not necessarily an elegant solution but it might work?

[FrancescoT]

Dear Roddyvet,

I suggest you to have a look at the following link.
http://www.installaware.com/forums/viewtopic.php?f=2&t=10060&hilit=SQLCMD

Regards