Compartilhar via

Sync Services for ADO.NET (OCS) CTP Now Available

  • Artigo

Today we launched the public CTP of the Sync Services for ADO.NET.  This is the current name of features we've been referring to as Occasionally Connected Systems (OCS). 

The SQL Server Compact Edition and Sync Platform teams have been working feverishly to get these bits available.  For those following my blog, you know the SQLce team has been busy shipping SQLce 3.1.  The number of requests for the private CTP exceeded our expectations, so for those that didn't receive the private CTP, we apologize, we just didn't have enough bandwidth to support the number of requests. With the public forum, we're now in a better position to support everyone.

Runtime Only
This is a CTP of the runtime experience.  For aprox 2mb, you can download the bits and run them on your Visual Studio / .NET FX 2.0 machine.  The Visual Studio Orcas CTP's will include SQLce 3.5, the sync runtime, along with the Sync Designer.  At this point the Feb CTP of Orcas will be the first public release of the sync designer.  I'll post a screencast of the designer soon.  But realize the Orcas downloads are quite large.  We'd love your feedback on the runtime, and it's just slightly larger than a floppy :)

Packaging
For this release, we're packaging the Sync Services with SQL Server Compact Edition v3.5.  This should not be confused with the recent release of SQL Server Compact Edition 3.1.  SQLce 3.1 and 3.5 are side by side, so installing this CTP should not affect your 3.1 installations.  If it does, we'd certainly like to know.

Some useful links:

Feedback: Please use the Sync Services forum as this is the best way for us to consolidate all the feedback.  Seeing feedback from others, will also help.  The SQLce and Sync product teams will be using this as the channel to gather and respond to feedback.

Thanks, and let the feedback begin,

Steve

Comments

  • Anonymous
    January 22, 2007
    Microsoft today released the first public CTP of Syncroniation Services for ADO.Net. I haven't...

  • Anonymous
    January 24, 2007
    Hi Steve Had a quick question for you on the Sync feature. We have a health care application (windows based) being developed using .Net 2.0 and 3.0 combination. The front end is on .Net 2.0 and the services are developed using WCF (.Net 3.0) Now we would need to provide this application to doctors working on remote location (field doctors). What would be the best approach which I could take whith out changing the technology used for development. I have come across couple of options : SQL Server merge replication and SCOAP. I then happened to come across your video on OCS Sync Framework. That seems to be a good proposition for adoption. Do you have the sample code/project which is sjown in the project and a writeup which can guide us as to how to adopt the OCS framework. Awaiting your respose at the earliest

  • Anonymous
    January 24, 2007
    Do you know how to use UDF from SQL 2005 into ADO.NET?? It will become quite easy and fast to operate a system. Regards, Messias

  • Anonymous
    January 24, 2007
    Hi Messias, I'm not sure if you meant to post this question here, as it doesn't appear you're asking if UDF's will work in OCS or SQLce, but rather how to use them through ADO.NET.  To get the ADO.NET team, you can reach them at their blog: http://blogs.msdn.com/adonet/ Steve

  • Anonymous
    January 24, 2007
    The comment has been removed

  • Anonymous
    January 27, 2007
    Steve Lasker has announced that the first CTP of the Microsoft Sync Services has been released. A new

  • Anonymous
    January 27, 2007
    Hi Steve, I am confused on how pricing will work for this.  Let's say I had to sync to Oracle for a customer and I wanted to use Sync Services for ADO.NET.  If I was using SQL Server Compact Edition on the remote it seems as though this should all work.  However, since there would be no SQL Server in the picture I am not sure how you would license this.  Would you charge a Client Access License (CAL)in this case?  If so, how much do you expect it will be?

  • Anonymous
    January 28, 2007
    The comment has been removed

  • Anonymous
    January 28, 2007
    Hi Steve I have downloaded the initial bits for ado.net sync service from the link below http://www.microsoft.com/downloads/details.aspx?FamilyId=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en I hope this is the correct one. Steve, I am planning to start development for the Sync feature as part of the product we are developing by end of March 07. Would be a good time by when the actual release for the ado.net sync service would happen along with the docs and manual.Cause, I dont want to rush up and start the development using sql merge/replication and then move to using syns service as the next solution. I hope it would be better to wait and start off with the syn service. I would also like to know if there are any samples available for the above ctp/bits which I have downloaded, of if some other sample is available as part of another ctp, i can try converting it to the ctp release which I have downloaded. Steve, also what is the link for the Sync Sevices forum.

  • Anonymous
    January 30, 2007
    Rajesh, I think you need to consider the architecture of your application.  Although it would appear from a 10,000foot view that there are now 2 sync options (3 if you include RDA), the reality is that they address completely different scenarios and will dramatically affect the way that you deploy your application.  For example with Sync Services you need to define everything in code, whereas Merge allows you to administer the publication.  Just this simple difference will lead to a completely different model for installation, support and maintenance for an application.  Just my 2 cents worth. Nick

  • Anonymous
    January 31, 2007
    Hi Steve Some more queries which just came across my mind today:

  1. We also have to support for availability of documents/images on the filed unit for doctors on the move. These could be for example medical history documents and images could be Diagnosis Images/X-Rays, etc..(big in size), Now the doctors can also make changes to the documents and if possible could do annotations to the images while on remote location and when they get back to the practice these also needs to be synchronised to the db server. So what could be the best way to accom;ish this, Do you suggest storing docs/images on the db server and making it available through sync or if its on a physical network location, how can I perform sync operations seamlessly on them.
  2. What would be the typical back-end db server requirement for using the sync services. Is SQL Server 2005 a must or would any flavor or SQL Server be supported.
  3. I am making use of SQL Ev as my client side database, is this a good option or can I make use of any other flavor of client side SQL DB.

  • Anonymous
    February 01, 2007
    Hi Nick Thanks for the usefull tips I actually want to get away with the burden of admistering publish/subscribe services which I feel is required for merge replication appraoch. I feel in that case going ahead with ADO.Net sync service would be a better approach, but is this ready to be used technology for now. Also, can I use any form of sql server on the back end while making use of ADO.Net sync services like can I make use of SQL Express. And on the client end I am planning to use SQL Everywhere, should that be ok too.

  • Anonymous
    February 05, 2007
    Rajesh - I'm glad the comments were useful. If you are interested in an extension to the samples provided across on the Synchronizer blog you might want to check out the Configuration Sample available here (http://softteq.com/sqlserverce/blogs/ssfaq/archive/2007/02/05/configuration-sample.aspx).

  • Anonymous
    February 16, 2007
    Steve - Whatever happened to the upcoming perf results you talked about weeks back?  And, do you have a performance comparison between Jet and SQLCE (i.e   simples INSERTs, UPDATEs, DELETEs per sec). Thanks in advance.

  • Anonymous
    February 16, 2007
    They released <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=02989F70-49AA-43D7-81B8-A651120F8D65&displaylang=en#filelist">documentation and C# samples</a> but I'm looking for VB samples. Let me know when/where I can get them. Thanks Steve!

  • Anonymous
    February 24, 2007
    The comment has been removed

  • Anonymous
    February 24, 2007
    The comment has been removed

  • Anonymous
    February 24, 2007
    Hi Beth, I know I promised some samples in VB, and I will get those posted.  Rafik has been doing such a great job, it fell lower on my priority list. If any of you haven't checked out Rafik blog, I'd definitely recommend it. http://blogs.msdn.com/synchronizer/  Rafik is our uber dev for OCS.  He’s been working on it from the start, and knows all there is to know as he’s either written, or worked on all the code.  Rafik has been absolutely instrumental in making sure we’re shipping the right scenarios and has been heavily engaged with the forums.  Based on your feedback, and Rafik pushing so hard, we’re going to work to get batching scenarios enabled in the Orcas release.  So, if you want to get it “from the horses mouth”, that’s Rafik.  He also maintains http://www.syncguru.com/ Steve

  • Anonymous
    February 28, 2007
    The comment has been removed

  • Anonymous
    March 01, 2007
    Hi Steve,  Does the current SQL Server Compact edition release have a provider for LINQ to SQL (formerly DLINQ)? From what I've dug up so far the answer would be no, but I wanted to verify. Thanks. Stephen

  • Anonymous
    March 01, 2007
    We don't yet have a LINQ to SQL (DLINQ), but we do have ADO.NET V3 Entities working over SQLce.  If you install the Sync Services CTP, you'll see we install a Entity dll for SQLce as well.  This CTP isn't directly compatible with the Orcas Feb CTP, so don't expect to do anything with it just yet.  It's possible the Feb CTP that was just released would enable Entities over SQLce, but I have to check to see what made it into that build. Steve

  • Anonymous
    March 02, 2007
    The comment has been removed

  • Anonymous
    March 21, 2008
    Hello Steve !! I m into a project where v are planning to have smart client which is occassionally connected.

  1. we are having wcf services running at the server which is mean to access the server database.
  2. to have sql express at the client which is free. there is scenerio where v need to synchronize the client db with the server.. this is only download only. Since there are some static data at the server. i m planning to use sync services for ado.net if u can point me to a link which has sample using sync services with wcf services and sql express at the client . v are using sql 2000 for the server database Regards Rajesh meh.rajesh@gmail.com

  • Anonymous
    March 29, 2008
    Hi Rajesh, We do hear requests for using Express on the client.  Unfortunately at this time, we don't have a sample or release date for if/when we'll ship an Express provider.  We do plan to ship an Express sample, but I don't have any dates on that as of yet.   You can post to the Sync Forum: http://forums.microsoft.com/sync/ShowForum.aspx?ForumID=1913&SiteID=75 and take a look for when we'll be making the Express sample available.  I know Liam is working on this. Steve

  • Anonymous
    February 03, 2009
    How can we use Microsoft Synchronization Services for ADO.NET with oracle or access database (with our sql server?) Is there any sample code?

  • Anonymous
    February 08, 2017
    I read your article & shared some more article like this.