Last edited Oct 18, 2009 at 8:10 AM by ErikEJ, version 1


ErikEJ Apr 23, 2013 at 7:30 PM 
Why not use sqlcecmd40.exe to create a new blank database instead, look at the tutorials ?

Caesaram85 Apr 22, 2013 at 5:37 PM 
Hi Erik!! I've a doubt with sqlce4.0 maybe you could help me with a few tips.

First, Using Export2SqlCe:
* I've connected to sql server 2008 r2 and create a script (schema and data) from a database (works like a charm, even using "exclude" opt!! You rulz).

Second, Using sqlcecmd40.exe:
* I want to delete all tables from a database (version sqlce4.0 .sdf), can i do this using -q "some query to drop all tables", i don't know how to do this with sqlce4 databse

* Then i want to run the script created using Export2SqlCe on the clear database. (i think it'll work fine, the script is "GO" separated statements)

Thanks in advance, César.

Note: Sorry for my poor english, i'm from Argentina, i speak spanish! XD

Caesaram85 Apr 22, 2013 at 5:27 PM 
maybe you should try changing script dir path and name without spaces like upd20101223.sql or verify if ur sql server compact version is similar than sqlcecmd (3.5 or 4)

ErikEJ Dec 24, 2010 at 2:19 PM 
It looks OK, do you have valid SQL statements in your file, separated by GO and new line?

hardywang Dec 23, 2010 at 9:24 PM 
How to use i switch?

D:\Sql CE Command>sqlcecmd -d "Data Source=D:\Projects\Database\Test.sdf" -i "D:\Project Upgrade\update 20101223.sql"

Is it the correct way? I ran it and nothing displays, nothing happens to my database.