what is the best way to transfer a SQL 2000 db to SQL CE db

what is the best way to transfer a SQL 2000 db to SQL CE db

Post by CafeCa » Wed, 10 Sep 2003 11:52:26


I used Pocket Access on PPC on PPC2002 age.
To transfer Access(.mdb) to PAccess(.cdb) is very simple, just copy .mdb
file to ppc after sync, Windows system will transfer it to .cdb
automatically.

Now, world has changed. How to transfer a SQL server db to SQL CE database
now? Somebody told me to create a db on ppc, then use RDA; somebody said
general sql script then copy to ppc and run it. What is the best way to do
it?

I just want to transfer database, needn't to sync them. Only a one way job.
Any suggestion? Thanx.
 
 
 

what is the best way to transfer a SQL 2000 db to SQL CE db

Post by Tom Pauwel » Wed, 10 Sep 2003 18:31:19

Hi,

If you just want to "pull" the data from the SQL 2000 db to the pocketpc, it
is best to use the RDA technique with SQL CE.
A good example can be found on:
http://www.yqcomputer.com/

Kind regards,

Tom Pauwels


database
job.