C# 数据库合并/复制

Question

我想为基于 MS Access 的应用程序创建一个复制解决方案。我有 2-4 个站点在数据库中创建内容，但它们都处于离线状态。到目前为止我的解决方案：

从文件菜单调用的函数：

class main
{
private void menuItemMergeUserData_Click(object sender, EventArgs e)
        {
            OpenFileDialog openDataFileDialog = new OpenFileDialog();

            openDataFileDialog.Title = "Select UserData file to merge";
            openDataFileDialog.InitialDirectory = System.IO.Directory.GetCurrentDirectory();
            openDataFileDialog.Filter = "Database files (*.mdb)|*.mdb|All files (*.*)|*.*";
            openDataFileDialog.RestoreDirectory = true;

            if (openDataFileDialog.ShowDialog() == DialogResult.OK)
            {
                ExternalUserManager UserManager = new ExternalUserManager(openDataFileDialog.FileName, CompanyID, dbManager);
                if (UserManager.MergeUserTables())
                    MessageBox.Show("UserData merged!", "UserData");
            }
            openDataFileDialog.Dispose();
        }
}

在类ExternalUserManager中调用的函数

 public bool MergeUserTables()
        {
            bool bOk = true;

            try
            {
                //databaseManager.CallMacro(dbMyFileName);

                conUserData.Open();


                daClass.Fill(dsUserData, "Class");
                daClassUsers.Fill(dsUserData, "ClassUsers");
                daCompany.Fill(dsUserData, "Company");
                daCurriculum.Fill(dsUserData, "Curriculum");
                daCurriculumExercises.Fill(dsUserData, "CurriculumExercises");
                daCurriculumMissions.Fill(dsUserData, "CurriculumMissions");
                daCurriculumTasks.Fill(dsUserData, "CurriculumTasks");
                daUserModes.Fill(dsUserData, "UserModes");
                daUserProfile.Fill(dsUserData, "UserProfile");
                daUsers.Fill(dsUserData, "Users");
                bOk = databaseManager.MergeDataSet(dsUserData);

            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "Reading UserData");
            }
            finally
            {
                conUserData.Close();
            }

            return bOk;
        }

在类DatabaseManager中调用的函数

public bool MergeDataSet(DataSetUserContent dsExternalUserContent)
        {
            bool bOk = false;
            try
            {

                this.dsUserContent.MergeFailed += new MergeFailedEventHandler(OnMergeFailed);
                this.dsUserContent.Merge(dsExternalUserContent);
                if(this.dsUserContent.HasChanges())
                    bOk = SaveUsers();
             }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "LogData Merge");
            }
            finally
            {
                conLogData.Close();
            }

            return bOk;
        }

数据集按照我想要的方式合并，但是导入数据库中的新行没有保存到数据库???

寻找此问题的解决方案，并有人说设置 AcceptChangesDuringFill = false 。尝试过，但这使得导入数据库中的所有行都被添加为源数据库中的新行。

Answer 1

如果所有应用程序都处于离线状态，为什么不直接将 mdb 文件复制过来呢？

我知道这很粗糙，但应该可以正常工作。