DB Schema mapping from 2003 to 2007

Y

ylashin78

Hi fellows,

We have developed some reports on PS 2003 that read data from tables
like msp_projects and the stuff. Our customer has upgrated his PS from
2003 to 2007. So, effectively our reports do not work anymore. For
example, the table msp_projects has it PK named proj_id as integer. In
PS 2007 it is renamed to proj_uid and it is currently unique
identifier. So, did Microsoft provided a way to make old work built on
the schema of 2003 to work on 2007. Or should I reimplement all the
work again at the database level. Also, is there a document to tell
the table/column mapping between 2003 & 2007 versions of the product


Appreciate your support

Thanks

Yousry
 
Top