title: Convert a MySql database to MS SQL Server 2005 with data?
body: <p>I'm trying to create a completely new database from an existing MySQL database, bringing over both data and schema, but so far the only way I've been able to do this is to first import the MySQL database into MS Access, and then into SQL Server 2005? Crazy right? Surely, there is a way that doesn't involve a tedious, custom time-consuming programming, right (perhaps using SSIS)?</p>
  
  <p>A few additions to my original description above:</p>
  
  <ul>
  <li>Its a pretty good size database (easily a few gigs).</li>
  <li>I'm working in an MS environment (asp.net, C#)</li>
  <li>I'm under a tight deadline so I'm looking for an automated process that requires little to no effort in the conversion process.</li>
  <li>SSIS would be the preferred way via BIDS (VS 2005)</li>
  </ul>
  
  <p>Thanks for all the great input!</p>