Visual Basic, Converting to new table structures

Converting to new table structures

Author	Message
Roy DeRouss #1 / 2	Converting to new table structures I support an application that works with Oracle tables that are defined by a commercial off-the-shelf product. These 63 tables (and fieldnames) will change radically with the next release of the software; thus, we are faced with retrofitting our existing code to work with the new tables. Here are some of the changes: - All tablenames are being changed. - Most fieldnames are being changed. - Fields from some tables are being split between two different tables now. - Some columns are being turned into rows having that column name as its key in a new table. 62 programs have to be changed. Things to look for in the code include: - SQL statements - References to fieldnames in the return recordsets There are a number of approaches that I'm considering: - Create a VB add-in to find and suggest replacements - Create a standalone program to flag and/or make all changes at once - Flag with special comment chars at end of line - Include commented-out old line - Use views to simulate some old table layouts Are there any tools out there already that can help to automate this process? I think that I know how to create a program to help do it, but an existing tool would be easier and probably more robust. SPEED Ferret is one that has been recommended, and I'm checking out that one. Any help appreciated! -- Roy DeRousse
Tue, 14 Sep 2004 02:59:17 GMT

Ira D. Baxte #2 / 2	Converting to new table structures What you want is a tool that can automate a massive change across your applications. Our DMS Software Reengineering Toolkit is based on generalized compiler technology, can parse VB programs and match specified code structures ("look for the old style") and replace them with new code structures, finally regenerating the modified VB6 text. Your particular task is interesting because all the changes are technically derivable from changes to the data schema. See http://www.semdesigns.com/Products/DMS/DMSToolkit.html. (Roy, contact me for further details.) -- Ira D. Baxter, Ph.D. CTO Semantic Designs, Inc. http://www.semdesigns.com Quote: > I support an application that works with Oracle tables that are defined > by a commercial off-the-shelf product. These 63 tables (and fieldnames) > will change radically with the next release of the software; thus, we > are faced with retrofitting our existing code to work with the new > tables. Here are some of the changes: > - All tablenames are being changed. > - Most fieldnames are being changed. > - Fields from some tables are being split between two different tables > now. > - Some columns are being turned into rows having that column name as its > key in a new table. > 62 programs have to be changed. Things to look for in the code include: > - SQL statements > - References to fieldnames in the return recordsets > There are a number of approaches that I'm considering: > - Create a VB add-in to find and suggest replacements > - Create a standalone program to flag and/or make all changes at once > - Flag with special comment chars at end of line > - Include commented-out old line > - Use views to simulate some old table layouts > Are there any tools out there already that can help to automate this > process? I think that I know how to create a program to help do it, but > an existing tool would be easier and probably more robust. SPEED Ferret > is one that has been recommended, and I'm checking out that one. Any > help appreciated! > -- > Roy DeRousse
Tue, 14 Sep 2004 23:24:53 GMT

Page 1 of 1

[ 2 post ]