Thanks for the input, it seems like your database was well designed so it's staying kind of the same. In our case, it looks like it's going to need a new design so the logic has to change, it's a complete rewrite and also we would need to import the data into the new system.

Thanks for the detailed input on the steps, it helps to know what another company has done going thru this process.