Rewriting old VFP app in C#, update SQL structures or not?
I have a number of older Visual Foxpro apps that we have decided to go ahead and rewrite using C#. Many of the older apps store data in our SQL server databases, which were designed back in the late 90's and early 2000s. Table structures and field names were different back then, variables and fields often used Hungarian notation. Most fields in most tables have a short 2-3 character table prefix then an underscore then a fieldname (example, Order table has order number field C(10) ord_ordernumber). Some tables are named for single record, others are named for plural records. Most sites listing best practices these days for database apps say to not use this naming convention for fields and tables.
If this were you redesigning an older app into a modern application framework, would you redefine the entire database structure using current best practices for naming everything, or would you keep the old existing data as-is, and just write your new app and use the old original table names?