title: Migration Data between two SQL Server databases
body: <p>I have a database called DB1 which installed in my local server with a desktop application and I have DB2 which contains some tables from DB1 (theses tables are the same of the related ones in the DB). So DB2 doesn't contain the full count of tables of DB1 but the structure of tables is the same. DB2 installed in cloud (hosted) with MVC application.</p>
  <p>So my question is, how can I synchronize data between the 2 databases. Anyone can say what they thinks about that.</p>
  <p>Note: All Databases are SQL Server DBs</p>