Resumen

MARTIN PENA, Nayibi; MARTIN MATA, Marcos Manuel; LABRADA QUIALA, Richel  y  LEYVA JEREZ, Gloria Raquel. Data replication process with Microsoft SQL Server for Reko Data Replicator. Rev cuba cienc informat [online]. 2016, vol.10, n.3, pp.171-185. ISSN 2227-1899.

ABSTRACT Reko Data Replicator intends to cover the principal needs related to data distribution between most popular databases managers as PostgreSQL, MySQL and Oracle, but did not have a mechanism to resolve data replication with Microsoft SQL Server. When you want to replicate data using the database manager Microsoft SQL Server required the use of traditional methods of data distribution, what caused a slow information management and possible errors in the data consistency. With the objective of developing a dialect for Reko Data Replicator that allow data replication with Microsoft SQL Server were used scientific methods of investigation, they were the theoretical methods: "Logical-Historical Analysis" and "Analytic-Synthetic". Also applied the agile development methodology Open Up spanning the entire software development process with small iterations. The software has been designed and implemented entirely using Open Source tools and class libraries with free licenses such as: Visual Paradigm, Eclipse STS, Apache ActiveMQ and Apache Tomcat. The Microsoft SQL Server dialect for Reko facilitate replication configurations for this manager, sync, send and receive data in Microsoft SQL Server manager and replicate data from Microsoft SQL Server to other managers, so it will be a mature and viable solution to the needs of systems using this replicator.

Palabras clave : data replication; dialect; Microsoft SQL Server.

        · resumen en Español     · texto en Español     · Español ( pdf )