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.
精彩评论