title: How to copy data between databases which has different table structures?
body: <p>I came to know how to copy data from one database to another database within one server, from this <a href="https://stackoverflow.com/questions/10028805/transfer-data-from-one-database-to-another-database">Transfer data from one database to another database</a> and between different servers from this <a href="https://stackoverflow.com/questions/603502/copy-table-to-a-different-database-on-a-different-sql-server">Copy table to a different database on a different SQL Server</a>, but I want to copy data of table from one database to another database which has different table structures. </p>
  
  <p>I will explain my requirements with an example. </p>
  
  <p>Consider a table contains basic information of patients such as <em>FirstName, LastName, Gender, Contact, Address, OpShortNotice, HasDiabetes, HasBloodPressure</em> and so on. </p>
  
  <p>In <strong>source database</strong> it has table named <strong>Patient</strong> and contain all the above fields, where as in my <strong>destination database</strong> has <em>FirstName, LastName, Gender, Contact, Address</em> fields in the table named <strong>Person</strong> and <em>OpShortNotice, HasDiabetes, HasBloodPressure</em> fields in the table named <strong>Patient</strong>. Then how to copy data from source to destination database? </p>
  
  <p>Like above simple example scenario, I have many tables and massive data to be migrated. As of now, my source and destination are in same server to make a trail of <strong>Data migration</strong> but definitely my future requirement will be with different servers. </p>
  
  <p>Please, Anyone help me to do this with scripts or any particular tool meeting my requirements.</p>
  
  <p>Thank you, in advance.</p>