title: MySQL to SQL Server transferring data
body: <p>I need to convert data that already exists in a MySQL database, to a SQL Server database.  </p>
  
  <p>The caveat here is that the old database was poorly designed, but the new one is in a proper 3N form.  Does any one have any tips on how to go about doing this?  I have SSMS 2005.  </p>
  
  <ol>
  <li>Can I use this to connect to the MySQL DB and create a DTS?  Or do I need to use SSIS?  </li>
  <li>Do I need to script out the MySQL DB and alter every statement to "insert" into the SQL Server DB? </li>
  </ol>
  
  <p>Has anyone gone through this before?  Please HELP!!!</p>