Showing posts with label Sync Framework. Show all posts
Showing posts with label Sync Framework. Show all posts

Tuesday, June 08, 2010

Need just some parts and pieces of the SQL Server 2008 R2? Like SMO, the Native Client, Report Builder v3, the SQL CLR Types, JDBC/PHP/DB2 Driver, etc, etc? Then you need the “Microsoft® SQL Server® 2008 R2 Feature Pack”

Microsoft Downloads - Microsoft® SQL Server® 2008 R2 Feature Pack

“The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.

File Name: SQL Server 2008 R2 Feature Pack.htm
Version: 10.50.1600.1
Date Published: 6/7/2010
Language: English
Download Size: 1 KB - 394.9 MB*


The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. It includes the latest versions of:

  • Redistributable components for Microsoft® SQL Server® 2008 R2.
  • Add-on providers for Microsoft® SQL Server® 2008 R2.

…”

Included in the SQL Server 2008 R2 Feature Pack are download links to;

  • Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2
  • Microsoft® SQL Server® PowerPivot for Microsoft® Excel
  • Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
  • Microsoft® SQL Server® 2008 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2007
  • Microsoft® SQL Server® 2008 R2 Policies
  • Microsoft® Sync Framework 2.0 Software Development Kit (SDK)
  • Microsoft® SQL Server® Compact 3.5 SP2
  • Microsoft® SQL Server® Compact 3.5 SP2 For Windows Mobile
  • Microsoft® SQL Server ®Compact 3.5 SP2 Server Tools
  • Microsoft® SQL Server® Compact 3.5 SP2 Books On-line
  • Microsoft® SQL Server® JDBC Driver 3.0
  • Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
  • Microsoft® System CLR Types for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Remote Blob Store
  • Microsoft® SQL Server® 2008 R2 Books On-line
  • Microsoft® SQL Server® 2008 R2 Upgrade Advisor
  • Microsoft® SQL Server® 2008 R2 Native Client
  • Microsoft® Core XML Services (MSXML) 6.0 SP 1
  • Microsoft® OLEDB Provider for DB2
  • Microsoft® SQL Server® 2008 R2 Command Line Utilities
  • Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2
  • Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET
  • Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Analysis Management Objects
  • Microsoft® SQL Server® 2008 Data Mining Add-ins for Microsoft® Office 2007
  • Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008
  • Microsoft® SQL Server® Driver for PHP 1.1
  • Microsoft® SQL Server® Migration Assistant
  • Microsoft® SQL Server® 2008 R2 Best Practices Analyzer

 

Related Past Post XRef:
SQL Server 2008 Feature Pack, August 2008 (i.e. The SQL2K8 RTM Feature Pack)

Monday, October 19, 2009

Microsoft Sync Framework v2.0 SDK and Redistributable RTM/RTW

Microsoft Downloads - Microsoft Sync Framework 2.0 Software Development Kit (SDK)

“Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services, and devices. Using Microsoft Sync Framework, developers can build applications that synchronize data from any source using any protocol over any network.

Version: V2RTM
Date Published: 10/18/2009
Language: English
Download Size: 35 KB - 146.3 MB*


Overview

Sync Framework 2.0 Overview
Sync Framework 2.0 expands on the capabilities offered by Sync Framework 1.0:

  • Adds features that cater to new scenarios or scenarios that were difficult to support.
  • Reduces the amount of work required to develop providers.
  • Supports more data sources with new built-in providers.
The major new features and improvements included in Sync Framework 2.0 are:
In Core Components:
  • Simple Providers: …
  • Flexible Filtering: …
  • Improved Conflict Handling: …
  • Data Conversion between Providers: …
  • Change Application Service:…
  • Tracing: …
In Database Providers:
  • New Database Providers (SQL Server and SQL Server Compact): Enable hub-and-spoke and peer-to-peer synchronization for SQL Server, SQL Server Express, and SQL Server Compact. …
  • Robust Memory-Based Batching: …
  • Provisioning and Management APIs: Provisioning and initialization activities that were previously exposed only through Visual Studio tooling have now been added to the database provider APIs….
  • Performance Improvements: The new database providers in this release have been thoroughly tested in large-scale scenarios in which a single server supports thousands of clients with hundreds of concurrent synchronization operations. …

Redistributable
To download the Microsoft Sync Framework 2.0 redistributables and bootstrapper, rather than the SDK package, click on the link: Microsoft Sync Framework 2.0 Redistributable Package

…”

Building your own synchronization is hard and that code is rarely a piece of core business functionality (sync may be but the code to do it rarely is). When/if I ever need to create my own sync’ing, this will be one of the first things I look at.

(via ActiveWin - Microsoft Sync Framework 2.0 Software Development Kit (SDK))

 

Related Past Post XRef:
Sync 101 - Samples for the Microsoft Sync Framework
Sync Framework v1 RTM’s (and includes ADO.Net Sync Services v2)
Using Microsoft Sync Framework in Visual Studio 2008 to Sync SQL Databases (SQL CE with SQL Server)
Microsoft Sync Framework CTP1 Released

Monday, April 20, 2009

UK MSDN Flash – Best of 2008 #1 in eBook form

IUpdateable from Eric Nelson - FREE MSDN Flash eBook with 13 technical articles spanning dynamic languages to game development to cloud computing

“…

Every two weeks we send an email out to tens of thousands of UK based developers. This email is called the MSDN Flash. The Flash contains many useful sections including a 400 to 500 word technical article on a developer related topic either written by a member of the Microsoft UK technical team or a member of the broader UK developer community. We have had some great articles over the years which to some extent end up “hidden away” in the archives of the MSDN Flash. This is a shame as the authors have worked hard to condense complex topics into short articles which are informative and take only a few minutes to read.

I decided it was time to surface the best of the articles on a regular basis and provide them in an easy to download and read eBook. This initial edition covers the period January 2008 to January 2009 but we aim to create a new eBook every six months from here on in. The next edition should therefore be out around August 2009.

image 

Table of Contents for #1

TABLE OF CONTENTS 2
INTRODUCTION 4
From the Editor 4
Would you like to become an author? 5
Subscribe to the UK MSDN Flash 5
VISUAL STUDIO 2008 7
Synchronization made Easy by the Sync Framework 7
WMI Provider Extensions in .NET Framework v3.5 8
Non-Attributed Data Contracts in WCF 9
Introducing the ADO.NET Entity Framework 10
Introducing the .NET Client Profile 11
XNA Game Studio 12
LANGUAGES 13
Combining Dynamic Languages and Static Languages 13
Getting Started with IronPython 14
TOOLS AND DEVELOPMENT PRACTICES 15
Pex: Automated testing for .NET 15
WEB 16
The Integrated Pipeline in IIS7 16
VISUAL STUDIO 2010 17
Introducing Parallel Extensions to the .NET Framework 17
CLOUD COMPUTING 18
Azure Services Platform 18
Windows Azure 19
MEET THE AUTHORS 20

image

While the page count isn’t huge, the information density seems pretty high. Short and sweet read for the train or bio break (did I REALLY just say that? :P  )

Friday, August 15, 2008

Sync 101 - Samples for the Microsoft Sync Framework

Microsoft Sync Framework - 3 (more) New Sync Samples - Sync 101 for Sync Framework SDK v1.0

"We have a couple more synchronization samples for you to take a look at.  These C# samples are based on Sync101 which is a sample template that allows us to show specific concepts relating to Sync Framework.  All of these samples have been updated to work with the latest v 1.0 release of Sync Framework SDK .

I am particularly excited about the remote change application sample (RCA) as it has been a common request to understand how to integrate Sync Framework with technologies like WCF and enable a service to manage the server provider componets of the Sync Framework. 

Each of the samples use the the SQL MetadataStore store for the metadata information for each replica database. This greatly simplifies the logic required to implement data synchronization between data stores. In these samples three in memory data stores are used to show how data collaboration can be accomplished and how the Sync Framework helps to minimize P2P complexities such as data conflicts / resolution and data deletions.

Sync101 with Metadata Store v1.0 ...

Sync101 RCA with Metadata Store v1.0...

Sync101 with Change Units...

..."

MSDN Code Gallery - Microsoft Sync Framework

"...

Current Samples
- Sync101 - Getting Started with Sync V1.0
- Contact Synchronization Sample - Outlook Sync
- Sync Services for ADO.NET v2 - Download Only Sync
- Sync Services for ADO.NET v2 - Adapter Builder
- SQL Express Client Synchronization Sample
- Sync Framework Tutorial
- Producing and Consuming FeedSync Feeds using Sync

[GD: Add the ones mentioned above too]

..."

I like the concept behind MS Sync (and that this could very well help us stop re-inventing the sync wheel). Now to get off my butt and start sync'ing something... ;)

 

Related Past Post XRef:
Sync Framework v1 RTM’s (and includes ADO.Net Sync Services v2)
Using Microsoft Sync Framework in Visual Studio 2008 to Sync SQL Databases (SQL CE with SQL Server)
Microsoft Sync Framework CTP1 Released

Wednesday, August 06, 2008

Sync Framework v1 RTM’s (and includes ADO.Net Sync Services v2)

Rob Tiffany's Windows Mobile Accelerator - Sync Framework v1 and Sync Services for ADO.NET v2 are now Generally Available!

“As of today you can download the Sync Framework SDK in 11 languages including Chinese (Hong Kong), Chinese (Simplified), English, German, French, Italian, Japanese, Korean, Portuguese, Russian and Spanish for AMD64, IA64 and x86 processors from the Sync Framework Download Center

What is Sync Framework?

Imagine being able to build a solution that seamlessly exchanges contact information between Outlook, a database contact management application, your mobile device and your service based contact management system.  Or how about a mobile device that connects with other devices to exchange pictures and videos.  How about being able to take data from any of your enterprise databases, file or enterprise systems and make it available offline for users to modify and sync back up to the enterprise.  All of these capabilities are possible with the Sync Framework and best of all, it is free on Windows platforms and licensable on non-Windows platforms!

…”

Microsoft Downloads - Microsoft Sync Framework v1.0

“Microsoft Sync Framework is a comprehensive synchronization platform for enabling collaboration and offline scenarios for applications, services and devices

Version: RTM1
Date Published: 8/5/2008
Language: English
Download Size: 1.1 MB - 504.3 MB*

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services and devices. Developers can build sync ecosystems that integrate any application, any type of data, using any protocol over any network.
The Microsoft Sync Framework provides a platform for taking web services and databases offline. In addition, it provides optimized P2P sync of any type of file including contacts, music, videos, images and settings. The extensible framework includes built-in support for synchronizing databases, NTFS/FAT file systems, FeedSync compliant feeds (formerly known as Simple Sharing Extensions), devices and web services.

Sync Framework Highlights

  • Add sync support to new and existing applications, services, and devices
  • Enable collaboration and offline capabilities for any application
  • Roam and share information from any data store, over any protocol, and over any network configuration
  • Leverage sync capabilities exposed in Microsoft technologies to create sync ecosystems
  • Extend the architecture to support custom data types including files


Sync Services for ADO.NET
Sync Services for ADO.NET is a Microsoft Sync Framework powered solution for synchronizing ADO.NET enabled databases in offline and collaboration scenarios. Sync Services for ADO.NET allows developers who are familiar with the concepts of ADO.NET to apply that knowledge to data synchronization through a very similar set of APIs to that of ADO.NET. Sync Services for ADO.NET provides the flexibility of a programming model like offline datasets and a richer synchronization feature set like that found in Merge replication. Sync Services for ADO.NET also supports synchronization over services, such as Windows Communication Foundation (WCF).

Sync Services for ADO.NET Highlights

  • Offline Database Synchronization: With Sync Services for ADO.NET you are able to build a solution where multiple remote clients connect and synchronize to a central ADO.NET database in a Hub-and-Spoke configuration. This enables occasionally connected devices to periodically connect and synchronize changes with a central ADO.NET database server. This topology is a common solution for remote workers such as sales reps or field service workers.
  • Collaboration Between Databases: Sync Services for ADO.NET also includes Peer-to-Peer capabilities. Through a custom Peer provider, collaboration between two or more SQL Server databases can occur (support is not available for SQL Server Compact). Unlike a Hub-and-Spoke architecture, this provider enables a SQL Server database to communicate and exchange information with any other SQL Server database. This type of scenario is useful in group scenarios where users (such as auditors) need to update information and then collaborate those changes with other group members.
  • SQL Server 2008 Integrated Change Tracking: If you are using SQL Server 2008, we recommend that you use the SQL Server change tracking feature. This feature addresses many of the issues of custom-tracking systems and provides a straightforward way to track changes. Change tracking is also supported by the Local Database Cache in Visual Studio 2008 SP1. Developers can now specify that the Configure Data Synchronization wizard should enable SQL Server change tracking on the server and generate the commands necessary to select and apply changes to the server database. Unlike custom change tracking systems, SQL Server change tracking does not require any schema changes in the server database. For more information, see the Visual Studio 2008 documentation.

…” [Description leached in full]

Microsoft Sync Framework - Top New Features in Sync Services for ADO.NET v2

“Today’s release of Microsoft Sync Framework includes the latest version of Sync Services for ADO.NET.  A great deal of work has gone into this release and I thought I would take some time to point out some of the top new features in version 2 since our previous release.

  • Peer-to-peer synchronization support:

  • Sync Services is now based on Microsoft Sync Framework:

  • Synchronize with devices:

  • Support for SQL Server 2008 Integrated Change Tracking:

  • Support for the new data types in SQL Server 2008:

  • The ability to trace the synchronization process:

…”

Though referenced in the SQL Server 2008 Feature Pack, August 2008 post, I thought this one deserved its own shoutout…

 

Related Past Post XRef:
Using Microsoft Sync Framework in Visual Studio 2008 to Sync SQL Databases (SQL CE with SQL Server)
Microsoft Sync Framework CTP1 Released

Tuesday, January 08, 2008

Using Microsoft Sync Framework in Visual Studio 2008 to Sync SQL Databases (SQL CE with SQL Server)

Vitaly's WebLog - Microsoft Sync Framework Support in Visual Studio 2008

"Microsoft Sync Framework is transport agnostic platform for automatic data synchronization across different types of datasources. It can be used for occasionally connected applications (smart clients) and p2p supplications. Previously we had to either use SQL server merge replication or write own synchronization framework. And now we have a solution from Microsoft that looks very promising. There is a good documentation for this on MSDN, if you need more details or code samples you will find them there.

While playing with Visual Studio 2008, I accidentally found new item type called "Local Database Cache". I turned out that this is really Microsoft Sync Framework integration with Visual Studio.

..."

Vitaly provides a short but very sweat example of using the MS Sync Framework in VS2008 to sync a local database cache (SQL CE 3.5 SDF) with a SQL Server 2005 DB.

(via DotNetKicks - Microsoft Sync Framework Support in Visual Studio 2008)

 

Related Past Post XRef:
Microsoft Sync Framework CTP1 Released

Sunday, November 04, 2007

Microsoft Sync Framework CTP1 Released

Microsoft Downloads - Microsoft Sync Framework CTP1

"... Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services and devices. Developers can build sync ecosystems that integrate any application, any type of data, using any protocol over any network.

The Microsoft Sync Framework provides a platform for taking web services and databases offline. In addition, it provides optimized P2P sync of any type of file including contacts, music, videos, images and settings. The extensible framework includes built-in support for synchronizing relational databases, NTFS/FAT file systems, Simple Sharing Extensions for RSS/ATOM, devices and web services.

Highlights

  • Add sync support to new and existing applications, services, and devices
  • Enable collaboration and offline capabilities for any application
  • Roam and share information from any data store, over any protocol, and over any network configuration
  • Leverage sync capabilities exposed in Microsoft technologies to create sync ecosystems
  • Extend the architecture to support custom data types including files

..."

Microsoft Downloads - Introduction to the Microsoft Sync Framework

"Throughout this document we will discuss the Microsoft Sync Framework which enables developers to create offline and collaboration scenarios for applications, services and devices.

...

The Microsoft Sync Framework includes all of the things required to integrate applications into an offline or collaboration based network, using the pre-created providers or writing new custom providers. This article outline some key concepts regarding synchronization providers, which will help you to understand how to create a provider.

..."

Microsoft Downloads - Microsoft Synchronization Services for ADO.NET v2.0 CTP1

"The download package contains the SQL Server Compact Edition 3.5 and Microsoft Synchronization Services for ADO.NET v2.0 CTP1

..."

Microsoft Downloads - Introducing Microsoft Sync Framework: Sync Services for File Systems Whitepaper

"Dive into the details of this new reusable Sync Services for Files Systems component we call simply, the File System Provider, along with enabled scenarios and sample code for getting started.

...

Towards this goal, we have developed a reusable provider for synchronizing the contents of file system directories on PCs and removable media such as USB thumb drives. In this article, I’ll cover the details of this new reusable Sync Services for Files Systems component we call simply, the File System Provider, along with enabled scenarios and sample code for getting started.

..."

Interesting... Added to my mental watch list.