开发者

Replication with SQL Server 2008 Web edition

开发者 https://www.devze.com 2023-04-08 01:19 出处:网络
I need to use replication between my databases. But me hosting provides only Web Edition of SQL Server. In 开发者_运维技巧web edition replication is not supported. May be anyone have some suggestions?

I need to use replication between my databases. But me hosting provides only Web Edition of SQL Server. In 开发者_运维技巧web edition replication is not supported. May be anyone have some suggestions? Thanks


If you are savvy with programming then you can accomplish a very slim form of replication through code. If not, you might be out of luck.

You can have DML triggers on your tables that you would normally have as articles for replication, and when the data changes log it to a table with the necessary information. Then have a scheduled task that runs an application to push those changes to the logical subscriber(s). Just an idea, but it looks like you may have to get creative.

0

精彩评论

暂无评论...
验证码 换一张
取 消