title: Data Migration from Legacy Data Structure to New Data Structure
body: <p>Ok So here is the problem we are facing.</p>
  
  <p>Currently:</p>
  
  <ol>
  <li>We have a ton of Legacy Applications that have direct database access</li>
  <li>The data structure in the database is not normalized</li>
  <li>The current process / structure is used by almost all applications</li>
  </ol>
  
  <p>What we are trying to implement:</p>
  
  <ol>
  <li>Move all functionality to a RESTful service so no application has direct database access</li>
  <li>Implement a normalized data structure </li>
  </ol>
  
  <p>The problem we are having is how to implement this migration not only with the Applications but with the Database as well.</p>
  
  <p>Our current solution is to:</p>
  
  <ol>
  <li>Identify all the CRUD functionality and implement this in the new Web Service</li>
  <li>Create the new Applications to replace the Legacy Apps</li>
  <li>Point the New Applications to the new Web Service ( Still Pointing to the Old Data Structure )</li>
  <li>Migrate the data in the databases to the new Structure</li>
  <li>Point the New Applications to the new Web Service ( Point to new Data Structure )</li>
  </ol>
  
  <p>But as we are discussing this process we are looking at having to rewrite the New Web Service twice. Once for the Old Data Structure and Once for the New Data Structure, As currently we could not represent the old Data Structure to fit the new Data Structure for the new Web Service.</p>
  
  <p>I wanted to know if anyone has faced any challenges like this and how did you overcome these types of issues/implementation and such.</p>