title: Move Data from Oracle to SQL Server
body: <p>I would like to copy parts of an Oracle DB to a SQL Server DB.  I need to move the data because the Oracle box is being decommissioned.  I only need the data for reference purposes so don't need indexes or stored procedures or contstaints, etc.  All I need is the data.  </p>
  
  <p>I have a link to the Oracle DB in SQL Server.  I have tested the following query, which seemed to work just fine:</p>
  
  <p>select
    * 
  into
    NewTableName<br>
  from 
    linkedserver.OracleTable</p>
  
  <p>I was wondering if there are any potential issues with using this approach?</p>