Currently we are connecting to different environment within different technologies. DBVisualizer is most key tool for us, to analyze all data through the one application. After changing visualization, It seems more user friendly, additional execution Query and programming based on the result through the CMD is also most friendly and time saving solution. Really loved it.
Pros
All Envrionment in One
Execution SQL in CMD line
Easy Connection with Complex Envrionment
Cons
DB Management Tools/ Administration Tools of each envrionment needs to be improve.
Query Profiller and monitoring
Even more DB Evinronments are Linked together, it's hard to write SQL statement to join each other.
Likelihood to Recommend
With GUI, Data Analyze can be simple even with a complex type of envrionment.
I have to manage several softwares databases and thanx to DbVisualizer, I can have all these database in one environnement with interresting tools. I have the same benefits of Microsoft App for sql server but for other, old database providers for wich I have to type every sql query to get or update something....
Pros
updating mannually data in a table
propose scripts for managing tables (create, select, update, insert ) or for update procedure
easy exports
Cons
I would like to just type the beginning of tha table name in the treeview on the lesft
automatic resize the columns length as Excel (all columns get the same length) , very usefull for table with 60 or more columns
duplicate a table without having to generate script and play agin script after changing the table name
Likelihood to Recommend
we can affect color to the databases : very usefull if you work on the production database and on the test database to pay attention on what you are going to do (for test or for real life)
I would like to hide some unusefull table in the treeview, I have a very bug database and some time I spend time to scroll to a table when I don't exactly know her name
VU
Verified User
Board Member in Information Technology (Automotive company, 201-500 employees)