与MS Sql Server 2005的预定Web同步

I have settled a web synchronization between SQLSERVER 2005 as publisher and SQLEXPRESS as suscriber. Web synchro has to be launched manually through IE interface (menu tools/synchronize) and to be selected among available synchronizations.

我已经确定了SQLSERVER 2005作为发布者和SQLEXPRESS作为suscriber之间的Web同步。必须通过IE界面(菜单工具/同步)手动启动Web同步,并在可用的同步中进行选择。

Everything is working fine except that I did not find a way to automate the synchro, which I still have to launch manually. Any idea?

一切都工作正常,除了我没有找到自动化同步的方法,我仍然需要手动启动。任何的想法?

I have no idea if this synchro can be launched from SQLEXPRESS by running a specific T-SQL code (in this case my problem could be solved indirectly).

我不知道是否可以通过运行特定的T-SQL代码从SQLEXPRESS启动此同步(在这种情况下,我的问题可以间接解决)。

2 个解决方案

#1

Denny Cherry, a SQL Server MVP, is writing a replacement for SQL Server Agent.

SQL Server MVP的Denny Cherry正在编写SQL Server Agent的替代品。

Denny's blog about it

丹尼关于它的博客

His Standalone SQL Agent project on Codeplex

他在Codeplex上的独立SQL代理项目

Using this, you would be able to automatically initiate code on a scheduled basis. But it's either this, or writing your own .NET app to kick off jobs. SQL Server Express Edition doesn't include any kind of automated job scheduling.

使用此功能,您可以按计划自动启动代码。但它要么是这样,要么是编写自己的.NET应用程序来开始工作。 SQL Server Express Edition不包含任何类型的自动作业调度。

#2

I don't really know about SQL Server web synchronization, but as SQL Express don't have an SQL Server Agent, you can write a C# console application that runs with the scheduled tasks.

我并不真正了解SQL Server Web同步,但由于SQL Express没有SQL Server代理,您可以编写一个与计划任务一起运行的C#控制台应用程序。

#1