I am currently working for a company that is redesigning
their data model towards a data warehouse type scheme. As
a result, there are an enormous amount of stored
procedures that need to be converted to match the new data
models.

My question is: is there a tool/app that can be given the
2 models and would parse the stored procedures and
recreate them with the new table links/structures, or
something similar?

Thanks,
-Brian