How to Synchronize from SQL Azure to SQL Server using Visual Basic

Yazan: SyncEXPERT | 26 January 2010 | No Comments
Categories: Microsoft Sync Framework

One of the primary goals was to reduce the complexity of getting started with synchronization using the Sync Framework.? Using the “SQL Azure Data Sync Tool for SQL Server” users can launch a wizard that configures synchronization from an existing SQL Server to a new SQL Azure database.?

Connecting to Pre-Release Versions of SQL Server 2008 Part Deux

Yazan: SyncEXPERT | 08 April 2008 | No Comments
Categories: Microsoft Sync Framework

Since posting on the topic of design-time and runtime connectivity to pre-release versions of SQL Server 2008 on the Data blog in November, the set of affected clients (applications, runtimes, and operating systems) have been officially released: Microsoft Visual Studio 2008, Microsoft .NET Framework v3.5, Microsoft Vista Service Pack 1, and Microsoft Windows 2008. Runtime connectivity from a client system configured with any of these released products to SQL Server 2008 November CTP or later provides full runtime access to the following features (for design-time functionality, see below):< ?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Â· Table-Valued Parameters

Â· New date/time data types

Â· Large user-defined types

Â· Support for very large FILESTREAM-attributed column data

Design-Time Connectivity Between Visual Studio and SQL Server 2008

Developers using Visual Studio 2005 or Visual Studio 2008 design tools will receive an error when trying to open a database on any pre-release instance of SQL Server 2008 without installing a Visual Studio patch. Pre-release patches for Visual Studio 2008 and Visual Studio 2005 enable the following Visual Studio functionality for SQL Server 2008:

Â· Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited.

o Note that table schemas still cannot be viewed or edited in this release.

Â· SQL CLR projects that target SQL Server 2008 can be created and deployed to the server.

Â· T-SQL and SQL CLR debugging are now enabled for SQL Server 2008.

Â· Data binding features in Client and Web Projects are enabled.

Pre-release versions of the design-time patches are currently available: the Visual Studio 2008 CTP patch is available for download here and the Visual Studio 2005 CTP patch is available for download here. Final versions of the patches will be available in the near future. For more information please see the “Connecting to Microsoft SQL Server 2008 from Microsoft Visual Studio 2005 and 2008″ whitepaper on MSDN.

Debra Dove

Program Manager Lead, Data Programmability

Connecting to Pre-Release Versions of SQL Server 2008

Yazan: dpblogs | 27 November 2007 | Comments Off
Categories: Microsoft Sync Framework

System.Data.dll, which contains the System.Data.SqlClient namespace, ships as part of the .NET Framework v2.0 SP1. This version of the .NET Framework ships with Visual Studio 2008, Vista SP1, and Windows Server 2008 and with each release of these products (beta, CTP, or release) there is a slightly different version of the .NET Framework.