title: How to copy contents of a table of multiple SQLIte DBs to one new SQLIte DB
body: <p>I have several DBs having a table called tbl_server_NE_details;</p>
  
  <p>The DBs are;
  SERVER_1.db,
  SERVER_2.db,
  SERVER_3.db,
  SERVER_4.db</p>
  
  <p>Each of them have a table tbl_server_NE_details</p>
  
  <p>I want to copy content of all tbl_server_NE_details to a new db;</p>
  
  <p>SERVER_ALL.db</p>
  
  <p>this should contain one table tbl_server_NE_details and it should have content from all the individual DBS.</p>
  
  <p>Following command works for one table but not for all;</p>
  
  <p>sqlite3 SERVER_1.db ".dump tbl_server_NE_details" | sqlite3 SERVER_ALL.db</p>