Project DescriptionThis 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.
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