Tried and True
The technology I've described was successfully implemented in production at the customer site in fall 2005.We separated the data loads of the mobile and online users without major changes in the application topology. We made the following relatively minor changes:
- configured an additional instance of SQL Server
- pointed online users to query the new database server
- wrote three custom stored procedures for all the current articles in the merge publications
- reinitialized all pull subscriptions after changing the value of the published_in_tran_pub property for all the articles
The customer wrote a code generator in TSQL to simplify the process of preparing custom stored procedures for 200-plus replicated tables.
Bidirectional transactional replication is transparent for both the SQL Server 2000 SP4 and SQL Server 2005 SP1 environments. The bidirectional and new peer-to-peer replication offered in SQL Server 2005 doesn't offer a conflict resolution mechanism. The improved merge replication mechanism in SQL Server 2005 is processing transactions of mobile users more quickly, but it remains trigger-based. So separating the online and mobile users in mixed environments could be necessary even after migration to SQL Server 2005 if you have hundreds of mobile users and a large number of online users.
End of Article
Prev. page
1
2
[3]
next page -->
