DbVisualizer vs. Visual FoxPro (Discontinued)

DbVis is our tool of choice when we need to work with a wide variety of Db vendors and versions. It allows us to replace several proprietary tools for accessing and, in part, managing database systems. It gives our customers and us a single base to work on databases. No need for us or them to install, learn, and pay for multiple solutions. If one would, for example, use ONLY one dbms, e.g., PostgreSQL, then DBVis could be a bit of an overkill.

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.

• Out-of-the-box support for many different databases.
• Intuitive UI for interacting with data.
• Flexibility of SQL Commander for writing scripts.
• Great support for working with JSON data in recent updates.
• Database connections over SSH.
• Table relationship visualization is very helpful.
• The tree view is well organized in how it splits out schemas.

• Treat data from files
• Reporting

Incentivized

• Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
• Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
• (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)

• 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

I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.

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

Never used

Incentivized

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] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.

Incentivized

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

• Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
• Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
• Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily

• 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