title: How to export an entire Access database to SQL Server?
body: <p>I've just got a lovely Access database, so the first thing I want to do is to move it over to a normal database management system (sqlexpress), but the <a href="http://hosting.intermedia.net/support/kb/default.asp?id=576" rel="nofollow noreferrer">only solution</a> I've found sounds like craziness. </p>
  
  <p>Isn't there an "<em>export database to .sql</em>" button somewhere? I have around 50 tables and this export might run more than once so it would be great if I didn't have to export all the tables manually. Generating a .sql file (with tables creation and inserts) would also be great since it would allow me to keep that under version control.</p>
  
  <p>I guess if it's not possible to do something simple like this I'd appreciate any pointers to do something similar.</p>