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

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
 
M

Miro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sql server 2000 to sql ce 1
Newbie question...Where to start?...(Compact Framework, SQL Server CE) 3
Visual Studio 2003 and SQL Server CE 3.0 7
Encryption: VB 2005 And SQL Server 2005 2
sql server 2005 tools configuration starts when I build a distribution project (VB 2005) 8
Error 30366 in VB behind VS(2005) project 1
Is it SQL 2008 or VB 2008 problem? I don't know 1
Questions about SQL Server CE 3

Top