PC Review


Reply
Thread Tools Rate Thread

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

 
 
CafeCat
Guest
Posts: n/a
 
      9th Sep 2003
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.


 
Reply With Quote
 
 
 
 
Tom Pauwels
Guest
Posts: n/a
 
      9th Sep 2003
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...icles/626.aspx

Kind regards,

Tom Pauwels
"CafeCat" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do) André Lavoie Microsoft Excel Programming 0 27th Sep 2005 01:50 PM
File Transfer....XP to 2000 ???? =?Utf-8?B?bWFydGlu?= Microsoft Windows 2000 1 20th May 2004 11:39 PM
PST file transfer: from OL XP to OL 2000 RC Microsoft Outlook Discussion 3 30th Apr 2004 09:32 AM
Re: I have win 2000 . upgrading to xp. how do I transfer with xp only Steve C. Ray Windows XP General 0 4th Sep 2003 04:57 PM
Re: I have win 2000 . upgrading to xp. how do I transfer with xp only Blue Ice Windows XP General 0 4th Sep 2003 03:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:00 AM.