title: Save dataset data to other database
body: <p>I have dataset connected with db. Dataset and TableAdapterManager were auto-created  by VS based on connection.</p>
  
  <p>I can do like <code>this.tableAdapterManager.UpdateAll(testcheckerDataSet);</code>
  It's working fine.</p>
  
  <p>Next I (using 3d party database editor) have copied .db file to "blank_testing.db" (2nd db) and then deleted all data from it. So It has just scheme without data.</p>
  
  <p>Now I (in the code) filled dataset with data from "testchecker.db" (1st db), changed data using from elements and want to save data to 2nd db and then to 1st db. I try to make it chaging connectionString for each adapter.</p>
  
  <pre><code>string originalPath = tableAdapterManager.Connection.ConnectionString;
  
         string ns = tableAdapterManager.Connection.ConnectionString.Replace("testchecker.db", "blank_testing.db");
  
          tableAdapterManager.Connection.ConnectionString = ns;
          group_testingTableAdapter.Connection.ConnectionString = ns;
          groupsTableAdapter.Connection.ConnectionString = ns;
          testingTableAdapter.Connection.ConnectionString = ns;
  
  
         this.tableAdapterManager.UpdateAll((testcheckerDataSet) testcheckerDataSet.Copy() ); // here error
  
  
          tableAdapterManager.Connection.ConnectionString = originalPath;
          group_testingTableAdapter.Connection.ConnectionString = originalPath;
          groupsTableAdapter.Connection.ConnectionString = originalPath;
          testingTableAdapter.Connection.ConnectionString = originalPath;
  
  this.tableAdapterManager.UpdateAll( testcheckerDataSet );
  </code></pre>
  
  <p>But I get error "concurrency violation the updatecommand affected 0 from 1". I think It happens because 2nd db has not data at all. </p>
  
  <p>So could somebody advise me how can I save current dataset to another db file and then again to first (original) db?</p>
  
  <p>Thanks.</p>