title: How to make your own table migration of two different tables
body: <p>I was wondering how I can make a table migration of two different tables.</p>
  
  <p><strong>Let me simply explain the question</strong></p>
  
  <p>So let us say we have database <code>a</code> and a database <code>b</code>.
  In both databases we have a table called <code>user</code>.
  The table of <code>user@a</code> is the develop table and the table <code>user@b</code> is the production table.</p>
  
  <p>Good. Now we have in <code>user@a</code> the following columns: <code>username</code>, <code>password</code>and <code>email</code>.</p>
  
  <p>In <code>user@b</code> we have the following columns: <code>username</code>, <code>password</code>, <code>email</code> and <code>role</code>.
  Now I need to merge these two tables.</p>
  
  <p>So it needs to make a new column (same as <code>user@b</code>) and store the data in the column.</p>
  
  <p>I have no idea of how I can do this.
  If someone can help me with giving me a start I would be pleased.</p>
  
  <p>I don't know if you should be able writing some websoftware to simply merge 2 databases. Since I'm a webdeveloper I may want to do that. So if someone can start me up with some more information... thanks!</p>