:? ---- SQL Script size issue

[yvijayakumar]

I generated an SQL script from MSSQL2000 and it is about 15mb in size and it contains ANSI scripts only. Each time I tried to create an mssql script in the InstallAware express, the software is getting hang. Is it related to any query size limitation in the software?

Also I need to know
How can I distribute unicode contents in the sql script?
How can I distribute applications developed using VB6?
How can I build a project compressed using the MSZip, CAB + MSI format?

[Gizm0]

15mb? :O
Do you have sample data scripted also on your SQL Script?If you do so, the best practice here is to contain the whole database as an Support File (or Using the File Bag plugin) on InstallAWARE and use the Attach Database function, to attach the database, after simply creating it. I can't imagine a database having 15MB of PLAIN TEXT as a creation script..

And as far as i know, there is no limitation on the script..Instead of pasting the SQL Script in the text prompt on the Plugin, try using the #FILESCRIPT function. For example attach the .sql script on the Support Files and in the textbox write #FILESCRIPT#$SUPPORTDIR$\\my_script.sql.

For more detail please refer to manual.

[yvijayakumar]

Attach database is not a good option, I think because the collation conflicts may occur in the end user machine. Any way I will the another method you suggested.

[Gizm0]

No, nothing conflicts by Attach Database, it uses the collation set on database and if it is set correctly, everything is fine.

[yvijayakumar]

Can I get installaware express samples

1. to redistribute MSDE 2000
2. to get the default Data path of SQL Server/MSDE
3. to attach databases to SQL Server/MSDE

And another thing, I re-opened a saved file and when I am trying to open the assemblies link from the explorer bar, an error message shows that miax occured an error. What is it?

[CandiceJones]

Please post sample requests in the Sample Scripts forum.