title: Data migration Access to SQL Server
body: <p>I'm about to migrate data from an old database (Access 2007, with around 30 tables) to a new SQL Server 2008 database structure, with additional information - around 80 tables. I have read a little about it so far, but this is a complete new area for me. Therefore that I ask this question.</p>
  
  <hr>
  
  <p><strong>A little more detail about what I want to achieve:</strong></p>
  
  <p>There is an old Access database with Access interface used as a program. The database started small with a few tables around 10 years ago and grew a lot bigger, to around 30 <strong>LARGE</strong> tables at this point of time. The problem facing with this old database is the large data sets (large tables/many columns in 1 table). This not only reduces the query performance, but also limits the data structure and information to be gathered.</p>
  
  <p>As a result, a new database structure had been designed. This is a fully normalized design, with over 80 tables. In fact, the old data is the same, but scattered over many more tables (lets say objects), with few of these table having some extra information about that object, which had not been gathered before. Of course, in future, this data will have to be recorded as well, so a new application (front-end) will be built over this database.</p>
  
  <hr>
  
  <p>Does anybody have any experience or knowledge about literature, good tools or other best practices with which I can transfer my old Access data from the old database into the new, big and normalized design?</p>
  
  <p>I'm digging deeper into SSIS and SSMA at this point, but perhaps someone can point me towards a good direction for my specific needs.</p>
  
  <p>Thank you a lot in advance.</p>