This project is read-only.
Project Description
This tools compare and synchronise table data. No schema synchronising included on this project.

Tested 1,000,000 data and comparison time is: ~200 ms.

Unlimited destination database support. Shared hostings: This product never use any server resource fully runs on desktop. It's only remote to remote data synronization.

ss2.png

Fully customizable xml configuration

<?xml version="1.0"?>
<TableDataSyncConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SourceServer Name="Source DB" ConnectionString="server=.;database=SourceDB;integrated security=true;Connect Timeout=120;" />
  <DestinationServers>
    <ServerConfiguration Name="Destination DB x" ConnectionString="server=.;database=DestinationDB;integrated security=true;Connect Timeout=120;" />
    <ServerConfiguration Name="*** Another Database ***" ConnectionString="server=.;database=AnotherDatabase;integrated security=true;Connect Timeout=120;" />
  </DestinationServers>
  <TableConfigurations>
    <TableConfiguration Name="Category" OnComplatedSqlString="">
      <ColumnConfigurations>
        <ColumnConfiguration Name="Id" IsPrimaryKey="true" IgnoreOnHash="true" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="Name" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="Description" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="IsActive" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
      </ColumnConfigurations>
    </TableConfiguration>
    <TableConfiguration Name="AnotherTable">
      <ColumnConfigurations>
        <ColumnConfiguration Name="UniqueId" IsPrimaryKey="true" IgnoreOnHash="true" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="Name" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="VarcharColumn" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="IntColumn" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="BitColumn" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="DateTimeColumn" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="TinyIntColumn" IsPrimaryKey="false" IgnoreOnHash="false" IgnoreOnUpdate="false" />
        <ColumnConfiguration Name="XmlColumn" IsPrimaryKey="false" IgnoreOnHash="true" IgnoreOnUpdate="false" />
      </ColumnConfigurations>
    </TableConfiguration>
  </TableConfigurations>
</TableDataSyncConfiguration>

Special Thanks:
Necati DANACI
Ömer ÇELİK

Last edited Nov 12, 2011 at 12:38 PM by omerfarukz, version 15