[Resloved] - Data upload/download between SQL Server 2000 and SQL Server 2000 CE

[karahim]

Hi!

How can I download and/or upload data between SQL Server 2000 and SQL Server 2000 CE using Active Sync as mode of transfer?

[Strider]

What exactly are you trying to do?

have you looked at RDA or Replication?

how about using a webservice to send the data to sqlserver

or get your pocket pc app to export data to file transfer it via activesync and then insert it to sqlserver from a desktop applicaiton

[karahim]

Thanks Strider for your reply.

For my Smart Device Application (VS 2003, VB.NET, CF 1.0), the application will maintain data on SQL Server 2000 CE, it does not use Internet/Remote Data Access. On periodic basis I need to:
- Upload data from PC (SQL Server 2000) to Pocket PC (SQL Server 2000 CE 2.0) using ActiveSync 3.7
- Download data to PC (SQL Server 2000) from Pocket PC (SQL Server 2000 CE 2.0) using ActiveSync 3.7

I cannot use any of these Remote Data Access and Replication which needs LAN, WAN or Internet access.

You suggested “get your pocket pc app to export data to file transfer it via activesync and then insert it to sqlserver from a desktop application”, this seems a complex solution.

I am trying to post this query on http://forums.microsoft.com/msdn/Sho...spx?ForumID=34
But something is wrong somewhere that I am unable to post my query. I followed their instructions from site's FAQ for "Why am I unable to post a new message to a forum?" but no success.

Please do me a favour and post my query on above mentioned forum.

Any other suggestion.

[Strider]

having you got a docking station for your device? If you do when you connect it to your PC if will be assigned an IP address and able to access the internet, network etc...

Can your device access the internet when docked?

If so you can use RDA or Replication or Even use SQLClient on the device to add data to SQL Server, while the device is docked


to access the site you need to have a hotmail/msn account thats all

[karahim]

Thanks Strider for your reply.

Yes I got docking station and can access internet when device is docked.

I found that I may achieve my objectives using RDA or Replication.


regards
karahim