SQL Server Mobile and SQL Scripts.

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


.

Relevant Pages

  • Re: Running a job in AIX
    ... command to show what is in the queue, ... we create a short script that sets our environment ... into an sql table, then runs an sql procedure to process the data in ... I would recommend that you get a copy of "Learning the Korn Shell" from ...
    (comp.unix.aix)
  • Re: Running a job in AIX
    ... command to show what is in the queue, ... we create a short script that sets our environment ... into an sql table, then runs an sql procedure to process the data in ... I would recommend that you get a copy of "Learning the Korn Shell" from ...
    (comp.unix.aix)
  • Re: Inserting Large amount of text into a memo
    ... memo text that will make SQL incorrect. ... creates ADO Command object and ... I think you misunderstand my question! ... The latter of my script ...
    (microsoft.public.scripting.vbscript)
  • Re: Global temporary table - data disappears about 1 time out of 15
    ... I 'select' a chunk of data into a global temporary table from a remote ... your script find that the data isn't there? ... I've trying wrapping the INSERT command in a transaction, ... SQL is useless - no such design ...
    (microsoft.public.sqlserver.programming)
  • Re: Running T_SQL script from Access (I cant get it right)
    ... Remove the GO, this is a batch command, not a T-SQL command. ... I generate a SQL script from Enterprise Manager through Generate SQL ... Dim fs ...
    (microsoft.public.access.adp.sqlserver)