SQL / SQLCE Synchronisation Issue??Help Needed Please!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steroche - 19 Aug 2005 22:57 GMT

Hi guys,
I have a problemo - basically i have one large SQL2000 DB. This is
edited / updated etc by users of the website i am developing. However i
also wasnt a SQLCE component as i want certain users to recieve
user-specific information from the database to their PPC's (I don't
have access to a device -just an Emulator). I presume some sort of
merge replication of the servers is required? I really don't have any
knowledge of this area but i have read somewhere that you need a server
with NTFS to take DB snapshots? I am running everything at home and
have IIS, SQLServer2K, SQLCE...basically everything on the same machine
and it has a FAT32 file system. Does this mean i cant synchronise my
databases?

I am using ASP.NET(C#) for the web app and ASP.NET Smart Device App in
VS2003.NET EnAR

Reply to this Message

Hilary Cotter - 20 Aug 2005 02:03 GMT

Merge replication is required for bi-directional replication between a SQL
Server and SQL CE clients. RDA can be used for 1 way replication.

You can test all you want with the emulator in fact it is a very good
choice.

You need a SQL Server any version, and VS Studio .Net and above, as well as
IIS or PWS. Then you need Active Sync and the SQL CE tools -
http://www.microsoft.com/sql/ce/downloads/default.mspx

When you configure connectivity support in IIS you will be prompted for a
snapshot share. Make sure this share is accessible by the account your
Pocket PC app is connecting the url with.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi guys,
> I have a problemo - basically i have one large SQL2000 DB. This is
[quoted text clipped - 11 lines]
> I am using ASP.NET(C#) for the web app and ASP.NET Smart Device App in
> VS2003.NET EnAR

Reply to this Message

steroche - 20 Aug 2005 18:47 GMT

Thanks for that Hilary,
So i have a question - is it possible in my scenario to use either of
these methods? If so which would you recommend?
I don't think i am able to create a snapshot share - i got an error
while trying to do so. It kept giving me errors as I couldnt access the
share i created. My machine is totally standalone and not on any
network although i did have to install a loopback adater to use my
emulator in VS. I am also only using an emulator.

Reply to this Message