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

[CafeCat]

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.

 

[Tom Pauwels]

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://smartdevices.microsoftdev.com/Learn/Articles/626.aspx

Kind regards,

Tom Pauwels