SQL Server CE and CR

  • Thread starter Thread starter Diego F.
  • Start date Start date
D

Diego F.

Hello, I'm new to CF developement and I want to start making some database
tests. I use VS 2003 and I'm gonna use Sql Server CE.

First of all, is Sql Server CE included in VS 2003? I see there is a
reference I can add, so I think it is, but I don't know if I have to
download anything else. I have also MSDE but no SQL Server.

Then, how do I create a SQL Server CE database?

Thanks for your attention,

Diego F.
 
Diego,

You have to create your SQLCE database programmatically on the device (or on the
emulator and copy it to the device). SqlCe is included with VS 2003 - you don't
need to download anything special for SqlCe.
 
Eduardo,

The only charge associated with SQLCE is if you connect to a SQL Server
database. In that case, the SQL Server must be running with per-processor
licensing or must have a CAL for the SQLCE connection. If you use it completely
stand-alone, there is no charge.
 
You can also create a database using full SQL Server and replicate it to the
device for your initial schema. I wouldn't, however, try scripting a full
SQL Server database and converting it to commands to run against your SQL
Server CE database unless you are ready to remove a lot of stuff and have an
understanding of what is and isn't supported.
 
There is also a tool that will assist with the code gen (in both eVB and
..NET) - I have not personally tried it...but I hear it's a nice little app.
It reads the schema of a database and generate the code (from SQL Server,
etc) - this way you can design the db on the desktop, point the app to it
and have the creation code for the DB generated for you:

http://www.gui-innovations.com/html/pocket_sqlgen.html
 
Is it possible connect to a MSDE database instead of SQL Server? In that
case, is it free?

Regards,

Diego F.
 
Thank you all for your answers. Then, should I include the code to create de
database in the application itself?

You say it's possible use SQL Server and transfer it to SQLCE. Is it
possible using MSDE? With MSDE I can use the VS IDE to create the databases
at least.

By the way, is any alternative using Access?

Regards,

Diego F.
 
Back
Top