title: Link tables in SQL Server from MySQL using OPENQUERY to get just updated records
body: <p>I am linking/copying tables from mysql to SQL Server. I have the linked servers setup and I can copy the tables. I need to know how to update only new records from the mysql database because there are 400,000 records on one table. Here is my query</p>
  
  <pre><code>INSERT INTO kiosk_test.dbo.CDS_STU_CLASS 
  FROM openquery(MYSQL, 'SELECT * FROM mycds.CDS_STU_CLASS')
  </code></pre>
  
  <p>How would you go about a stored procedure or query to update only the new records? I have tried researching the best I can to no real answer. </p>