newbe: one vb project for sql server and sql server CE

  • Thread starter Thread starter Hans Korngold
  • Start date Start date
H

Hans Korngold

Hello everybody,
is it possible to develope a project where I can switch between sql server
db and sql server CE?
If yes, is there any sample / ressources in internet?
If not, ist there any tool to "convert" a sql server vb project to the sql
server CE project?
Thanks
Hans
 
The short answer is yes.

Make sure you develop for the CE version as the
SQL express or higher versions allow more options such as "stored
procedures"...

Create 2 projects...
First one, add a new sqldatasource, and select the datafile to be a compact
edition..

second project, add a new datasource and select an sql express database

do you notice how in the compact edition it added extra dlls' to the
program?

So basically as long as you program towards a CE database, the dll's are
added automagically.

Then at runtime you can hit the proper database with a switch or something.

Do you require more detail?


Miro
 
Back
Top