title: Merge Multiple Databases into a Single Database
body: <p>All, I have to create a single database which has a basic schema. This database is going to be large (100GB plus), and is to be used as a data warehouse. Now, the creation of this database is currently being performed in 'one-hit' through a C# code; pulling data from a number of different sources. Due to the sheer volume of data, this creation is causing some problems. It has been decided that instead of creating a single database in one go; to </p>
  
  <ol>
  <li>Create several smaller databases containing the core data tables.</li>
  <li>Merge the smaller databases into a single larger database.</li>
  <li>Build the schema/add the relevant constraints.</li>
  </ol>
  
  <p>My question is two-fold.</p>
  
  <p><strong>1. What is the best way to merge multiple databases (with identical schemas/table structures)?</strong></p>
  
  <p><strong>2. Is there a better way of going about creating this data warehouse (extremely large database)?</strong></p>
  
  <p>Thanks for your time.</p>