Re: New to Merge/Replication
- From: "William Vaughn" <billvaNoSPAM@xxxxxxxxx>
- Date: Thu, 2 Aug 2007 09:40:48 -0700
ADO.NET 3.0 includes "Synchronization Services" that does not require IIS. It is in beta (2) now and it's expected to RTM before the end of the year.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message news:uHaw5$L1HHA.4816@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the information Ginny. I did download the BOL a while, but never dug down into it until now .... and what I read was disturbing:
"If this is the first publication created for this server, the Publication Wizard prompts you to configure the default snapshot folder location. The snapshot folder holds the snapshot files that contain the schema and data for published tables. The IIS user must be able to read these snapshot files so that it can download the files to the smart device."
Is microsoft kidding me .... is this just the IIS USER????????????????? Or does it appear that I need IIS Services (such as FTP) running????????????????????????
Microsoft has got to be kidding me??????????????????????? As I've stated before, and I think the entire World would agree with me ... IIS is the biggest piece of garbage MS ever produced.
It's riddled with security holes and it is not to be trust at all ... even with Anti-Virus software and firewalls. My clients are not computer-saavy, they are local town or county government workers, and they don't have technical people on staff. They are NOT going to be running IIS and we don't want them to. What if IIS goes down? How would they know? How are they gonna bring it back up without calling me to BLAME ME that stuff isn't working now.
It was my deepest hope that Merge/Replication between SQL Compact Edition and SQL Server 2005 Enterprise Edition would have it's own sync services NOT dependent on IIS.
I'm sorry about the rant .... but is IIS really needed .... or can it be avoided? Thanks!
Tom
"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message news:99C7FD2C-4BC7-4752-9D95-066EC6062631@xxxxxxxxxxxxxxxxTom,
The best reference on merge replication for SQL Compact is the SQL 2005 Compact Books Online. There is also some good info here: http://www.microsoft.com/sql/editions/compact/default.mspx
You can use merge replication with SQL Server on your main desktop serving as the publisher with SQL Compact on PPC, TabletPC, or other desktops as subscribers, so that would probably be the easiest solution for you. You might also want to look at Sync Services for ADO.Net, currently in beta: http://blogs.msdn.com/stevelasker/archive/2007/03/18/QAforOCS_2D00_SyncServicesForAdoNet.aspx
--
Ginny
"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message news:elBuyaT0HHA.5408@xxxxxxxxxxxxxxxxxxxxxxxI will be developing some apps on a PPC with WM 5.0 and will have the Compact Edition.
Similiarly, my client my have tablet PC's with either Compact Edition, or Access, or SQL Server Express on it.
The main desktop will have the full blown SQL Server, probably 2005 or 2007 version.
I presume that I can use Merge/Replication for the sync merging. As I have looked on here, with Compact Edition and the full SQL Server you can do Merge/Replication. Where is the best place to read up on merging/sync replication?
There are 3 scenarios I see, and the first two the most common:
1) there will be some tables for download only ... for lookups
2) Data will be uploaded from the PPC to the SQL Server, AND THEN I want those records on the PDA to be expunged and deleted.
3) One table ... eventually may have to be really synced with both records in SQL Server AND on the PDA.
Also ... what is the best way to do merge replication for the Tablet PC. Should I use Compact Edition there also, SQL Server Express, or Access. So long as they can do Merge/Replication to the main SQL Server, that's great.
Thanks for any help!
Tom
.
- Follow-Ups:
- Re: New to Merge/Replication
- From: Tom Holmes Jr.
- Re: New to Merge/Replication
- References:
- Re: New to Merge/Replication
- From: Tom Holmes Jr.
- Re: New to Merge/Replication
- Prev by Date: Re: Upgrading from cf v1 to v2 merge replication problem.
- Next by Date: Re: Secure data in SQL Server 2005 Mobile Edition
- Previous by thread: Re: New to Merge/Replication
- Next by thread: Re: New to Merge/Replication
- Index(es):
Relevant Pages
|
