DbVisualizer vs. Visual FoxPro (Discontinued)

Whenever you have to access data sources from more than one database engine provider, you should consider using DbVisualizer for the task. Switching between multiples IDE consumes time and resources (memory), and you also need to learn menus, shortcuts, etc., for each IDE, while using DbVisualizer allows you to work consistently no matter which database engine you are connecting. You can use it to simply navigate through data structures, write SQL sentences or even create new tables and views, develop stored procedures, etc.

Incentivized

Legacy applications already on VFP are a good candidate. If you plan to move to iOS and Android apps, VFP is not for you. Also, in future access to VFP programmers may be limited. You could use VFP as a powerful database tool. I know of many programmers who love to exploit the features of VFP to create easy to use applications.

• Timed queries that add their result to the result grid for every execution are helpful. Creation of graphs also extremely helpful.
• Query history and auto-recover feature makes sure we don't lose our queries.
• Actions like exporting grids to Excel or other tools is a very easy task.

Incentivized

• Treat data from files
• Reporting

Incentivized

• does not handle lost connections well (specially after stopping a running query) (mysql). eg. after hitting stop, and then hitting run again, it can sometimes look like its running the query, but it isn't actually!
• filtering on databases window is clunky (why the need for filtering certain object types at a time? just filter everything, google style)
• altering table, adding columns (NOT to the end of the table's columns, but earlier) is not supported (mysql) even though the db supports it (alter table add column BEFORE..)

Incentivized

• Microsoft stopped selling this and stopped supporting it in 2014. It still works on Windows 10, but if you have a problem, you are on your own.
• The look and feel of screens and displayed text is getting a little dated.
• It's really designed for desktop/server environments rather than the cloud.

Incentivized

We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.

Incentivized

Menus are simple and well organized. You can use the same shortcuts no matter which database engine you are connecting to. Configuration of data source connections is simple while keeping all required options.

Incentivized

There are several easy to use and powerful features of VFP that programmers like.

Although MS has discontinued support of VFP there is a good community of programmers that are available for help. In fact we have several programmers at Apptread that are skilled not only in VFP but also .NET so that if there is a need to migrate some parts of applications to .NET , it is easy for us to do that.

DbVisualizer provides a good value when compared against other 3rd party products with similar features as well as products with similar functionality made by the database vendors. The user interface is good and user friendly / intuitive and easy to learn. It doesn't take too long for an experienced DBA / database developer to come up to speed.

We are only using FoxPro because it is the only way to add custom plugins into the software we use to manage our stock. FoxPro is a semi-oriented object language and should clearly not be compared with recent technologies.

Incentivized

• The institution is of the governmental type, therefore we do not measure the commercial impact of using this tool
• The impact on the benefit of the population is always positive with tools that streamline our processes, and DbVisualizer is one of the best

Incentivized

• Positive impact is that the value of FoxPro applications has continued to increase over the years, so we are in high demand for our services.
• Negative impact is that sometimes you have difficult to support scenarios where you might have to spend many hours to just keep something functional.
• A negative impact is that this language is taught in very few places, either in schools, or private learning centers.

Incentivized