title: Convert datetime column to datetime2 column in SQL Server?
body: <p>I have a SQL Server 2005 database with a <code>datetime</code> column. There is already data in the table but now the customer needs dates before 1753. So I decided to migrate the database to a SQL Server 2008 to use the <code>datetime2</code> type. </p>
  
  <p>However I can't just switch the type of the column from <code>datetime</code> to <code>datetime2</code>. Is there a way to do this conversion or do I have to reimport the data? </p>
  
  <p>Thank you,</p>
  
  <p>Daniel</p>