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?
:? ---- SQL Script size issue
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.
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.
Panagiotis Kefalidis
Software Design Team Lead
\"In order to succeed, your desire for success should be greater than your fear of failure\"
Install[b]Aware[/b] Software Corporation
Software Design Team Lead
\"In order to succeed, your desire for success should be greater than your fear of failure\"
Install[b]Aware[/b] Software Corporation
-
yvijayakumar
- Posts: 4
- Joined: Thu Jan 25, 2007 4:25 am
No, nothing conflicts by Attach Database, it uses the collation set on database and if it is set correctly, everything is fine.
Panagiotis Kefalidis
Software Design Team Lead
\"In order to succeed, your desire for success should be greater than your fear of failure\"
Install[b]Aware[/b] Software Corporation
Software Design Team Lead
\"In order to succeed, your desire for success should be greater than your fear of failure\"
Install[b]Aware[/b] Software Corporation
-
yvijayakumar
- Posts: 4
- Joined: Thu Jan 25, 2007 4:25 am
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?
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
- Posts: 904
- Joined: Thu Dec 22, 2005 7:03 pm
- Contact: