C#同步SQL Server数据库中的数据--数据库同步工具[同步已有的有变化的数据]
2. C#同步SQL Server数据库中的数据--数据库同步工具[同步新数据]
3. 分析下自己写的SQL Server同步工具的性能和缺陷
接着写数据同步,这次可以把有变化的数据进行更新了:
1.SQL批量更新函数:
/// <summary>
/// Note: for columns, the first string must be primary key name!
/// </summary>
/// <param name="server"></param>
/// <param name="database"></param>
/// <param name="uid"></param>
/// <param name="password"></param>
/// <param name="tableName"></param>
/// <param name="columns"></param>
/// <param name="ignoreUpdateColumns"></param>
public void BulkUpdateTo(string server, string database, string uid, string password, string tableName, List<string> columns, List<string> ignoreUpdateColumns)
{
string primaryKeyName = columns[0];
string connectionString = "Server=" + server + ";Database=" + database + ";User Id=" + uid + ";Password=" + password;
// Create destination connection
SqlConnection destinationConnector = new SqlConnection