We are looking to upgrade our current VB5 / Btrieve 6.15 programs to a new or upgraded database. I am looking for recommendations as to which DB you experts prefer, and why.
Also, one of our conditions is to minimize the conversion effort for the programming that we already have in place. This code is based on the DAO table/index/seek paradigm. Since ADO now has .index and .seek, comments on using your DB with these methods/properties would be appreciated.
(Yes, I know that converting to relational code is probably the way to go, but it has two problems: (1) it is slower for some cases, and (2) a four person MIS shop, with the ability to dedicate only one developer to the conversion, does not have the resources to update the number of lines of code that we have in use without some shortcuts :)
Notes: MS Access is not an option - we already use it for some purposes, but it does not have the capacity to handle all of our data.
DB must be supported on Novell Netware (preferred) or Windows NT. The management does not want to get into any flavor of Unix, or any non-PC based solutions.
Points will be given to more than one expert. I will award additional points based on informational quality of the answers. More than one answer on a given DB may recieve points. General answers relating to a conversion may also be given points. Points may also be awarded for links to good DB Benchmark comparisons and/or feature comparisons (preferably from sites other than the DB's home site). Up to an additional 2000 points will be awarded for answers on this question.
Help? :) Thanks