I have an application written in another language (CASL) on a Windows Mobile
platform and I want to convert the databases to SQL Mobile so that I can
create a version of my app for Smartphones. The databases for the CASL app
use a single table that has 17 columns and anywhere from 100 plus to 700
plus records. There are 72 databases in all; 36 data tables and 36 index
tables. The index tables have 4 columns and less than 100 records each.

I am creating the tables on the emulator since, for some reason or the
other, running a Create Table script in the VS IDE seems to bomb out. The
Insert Table script also bombs our in the VS IDE. I have the tables
completed and wrote a little app that creates the SQL scripts of the data
from a CSV file. Two things are happening: 1) the script is truncated
somewhere around the 246th record and 2) the script doesn't execute unless I
do one Insert command at a time.

The first one I can fix by cutting the SQL script files into smaller files.
The second problem is a major issue. Query Manager in SQL Mobile doesn't
like the GO command after each insert and removing the GO command crashes at
the second Insert of the script. Is there any way to run a SQL script of
more than one command without having to do it one command at a time? The app
is a freeware app and I don't want to spend that much time just creating a
database. All of the scripts work perfectly in SQL Server 2005.

Thanks,

John