title: how to do Data replication on MS SQL Linked server
body: <p>We have created a MS SQL Linked server for a MYSQL database...I have a data replication questions related to linked server</p>
  
  <p>1.Once a MS SQL Linked server is created between MYSQL and MS SQL,if we insert any new data into existing tables of MYSQL,does the data get automatically replicated to the MSSQL Linked server?</p>
  
  <p>2.If we add new tables or columns how to data replication is handled between MYSQL and MS SQL linked server?is there an automated way to replicate data?</p>