SQL Server Replication
Microsoft SQL Server Replication Has Significant Limitations for Mobile Applications
Microsoft® SQL Server™ provides replication tools for copying, distributing and synchronizing data between databases. While this product has many strengths in addressing the needs of the real-time enterprise, its features are not ideally suited for supporting mobile applications or the distributed network. At first glance the merge replication tools in SQL Server may seem like an appropriate solution for distributed computing, but set-up and configuration of this functionality can be complicated – some of the most complex steps are not automated and may require significant involvement of a Microsoft network administrator. SQL Server replication operates primarily on a “hub and spoke” network model, limiting its value in environments where a different model is ideal. And this Microsoft solution relies on a cumbersome initial and periodic snapshot-and-restore process to re-synchronize the sites in a network, which may result in significant and unnecessary downtime. For a leading replication alternative to SQL Server, leading enterprises have chosen Progress® DataXtend® RE from Progress Software.
A Powerful Alternative to SQL Server Replication
DataXtend RE (Replication Edition), from Progress Software, is a robust replication alternative to Microsoft SQL Server, enabling enterprises to efficiently distribute data from existing databases to remote offices and mobile workers. DataXtend RE provides central office access to users and offices on the edge of the enterprise network, where connectivity may be intermittent. With DataXtend, organizations can deliver data efficiently across multiple sites, geographies, platforms, and database management systems, by virtue of a patented technology for two-way, read-write replication of databases. With DataXtend, deploying and supporting distributed applications is just as cost-effective as deploying Web-based applications – but without the network limitations one normally expects to find when accessing a central server and database.
Comparing DataXtend and SQL Server Replication
DataXtend offers significant benefits over SQL Server in supporting mobile applications in a distributed computing environment. DataXtend is installed through a simple point-and-click process, or optionally through a single command line. DataXtend supports peer-to-peer and master-slave configurations, in addition to the hub and spoke model. And DataXtend provides greater availability over SQL Server replication by continually exchanging updates between all replication partners using a compressed data stream secured with Triple DES encryption.
In addition to database management software and solutions for mobile application development, Progress also provides object database solutions and an object oriented database management system, as well as platforms for event processing, the deployment management of trading algorithms, and more.
Best Practices for Distributed Data Replication
Comparing Microsoft SQL Server Replication
Network World:
Data Fabric Keeps Information Consistent
> Read Article