title: Django: copy data from one database to another
body: <p>I have two sqlite.db files. I'd like to copy the contents of one column in a table of on db file to another.</p>
  
  <p>for example:</p>
  
  <p>I have the model Information in db file called new.db:</p>
  
  <pre><code>class Information(models.Model):
          info_id = models.AutoField(primary_key = True)
          info_name = models.CharField( max_length = 50)
  </code></pre>
  
  <p>and the following information model in db file called old.db:</p>
  
  <pre><code>class Information(models.Model):
              info_id = models.AutoField(primary_key = True)
              info_type = models.CharField(max_length = 50)
              info_name = models.CharField( max_length = 50)
  </code></pre>
  
  <p>I'd like to copy all the data in column info_id and info_name from old.db to info_id and info_name in new.db.</p>
  
  <p>I was thinking something like:</p>
  
  <pre><code>manage.py dbshell
  </code></pre>
  
  <p>then</p>
  
  <pre><code>INSERT INTO "new.Information" ("info_id", "info_name")
  SELECT "info_id", "info_name"
  FROM "old.Information";
  </code></pre>
  
  <p>This doesn't seem to be working. It says new.Information table does not exist... any ideas?</p>