Initiating Sync to SQL Azure using SQL

Yazan: SyncEXPERT | 26 March 2010 | No Comments
Categories: Microsoft Sync Framework, Miscellaneous

For those of you who have tried SQL Azure Data Sync you likely know that the way that we execute synchronization from SQL Server to SQL Azure is through the use of SQL Agent.? One of the handy parts of SQL Agent is the ability to schedule synchronization based our your own requirements.? However, in some cases you actually want to execute synchronization based on some event that occurs within the database or even through an external application.? For that, there is a handy stored procedure called sp_start_job within the MSDB database which you can call to execute synchronization.? For example, I created a sync relationship between SQL Server and SQL Azure database using my AdventureWorks database and as a result there was a SQL Agent created called ‘SyncToSQLAzure-Sync_AdventureWorksLT2008′.? Using this, all I need to do is go to the msdb database (use msdb) and execute the following SQL: exec sp_start_job ‘SyncToSQLAzure-Sync_AdventureWorksLT2008′ If you want to get information on the job, you can also use sp_help_job . Liam

Announcing Entity Framework & ADO.NET Data Services RTM!

Yazan: SyncEXPERT | 02 October 2008 | No Comments
Categories: Data Technology

Announcing Entity Framework & ADO.NET Data Services RTM! We are excited to announce the RTM of the Visual Studio 2008 SP1 and the .NET Framework 3.5 SP1, including the RTM of the ADO.NET Entity Framework and ADO.NET Data Services, which raise the level of abstraction for database programming and supply both a new model-based paradigm [...]

PDC 2008 – Los Angeles, CA – Oct. 27-30

Yazan: SyncEXPERT | 25 September 2008 | No Comments
Categories: Data Technology

Microsoft’s premier developer event, the Professional Developer Conference, is almost here. PDC 2008 will feature more than 160 sessions covering a wide range of topics including a number of great sessions from the Data Programmability Team, including the ADO.NET Entity Framework, ADO.NET Data Services and Project “Velocity”. Developing Applications Using Data Services Presenter: Mike Flasko [...]