Re: Can a .frm be reverse engineered to a .per

> In article: <316C3128.64F3@compans.com> Nick Hollingsworth > <nickh@compans.com> writes: > > > > Due to circumstances that I won't bore you with we are > rebuilding one > > of our development systems and have a full set of frms but > no pers for > > them. > > It looks like we are going to have to sit down and retype, > unless someone > > knows of some sort of reverse engineering tool that could do > the job. > > Given the situation it would not have to be perfect! > > Any suggestions? > > > > > I dont know how much this helps, but: > > There are two environment variables:DBSCREENDUMP DBSCREENOUT > set these to the files you want to store the output in. > > Then - run you program/form whatever and press Control-P > this will dump the screen to the file. This may help with the > screen section :-) > Mike's suggestion is only the first step. Determining attributes would take a lot longer. For some reason the format of the .FRM file is in a strange order and many things are "tokenised". If the forms are 4GL forms it is a lot easier than SQL forms as there are far fewer options. I managed to do one in two days. I suspect it would get faster with time. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc