Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [tools]

Questions about any and all tools related to databases or the job of database administration.

83 questions
1500
votes
8 answers

How do I list all databases and tables using psql?

I am trying to learn PostgreSQL administration and have started learning how to use the psql command line tool. When I log in with psql --username=postgres, how do I list all databases and tables? I have tried \d, d and dS+ but nothing is listed. I…
Jonas
  • 31,495
  • 27
  • 59
  • 64
48
votes
9 answers

Is there a tool like Microsoft's "SQL Server Profiler" for MySQL?

While developing on MySQL I really miss being able to fire up a profiler. I find SQLyog is a good enough replacement for Query Analyzer but have not found a tool that works like SQL profiler. For the MySQL folk who have not seen Microsoft's SQL…
Sam Saffron
  • 1,094
  • 1
  • 10
  • 12
42
votes
7 answers

Why should I use Visual Studio 2010 over SSMS for my database development?

Visual Studio 2010 introduces database projects and a whole array of related features that supposedly facilitate database development. I've used SQL Server Management Studio (SSMS) for many years to do my database development without issue. Why…
Nick Chammas
  • 14,490
  • 17
  • 74
  • 121
25
votes
8 answers

Tool to generate large datasets of test data

Many times when trying to come up with an efficient database design the best course of action is to build two sample databases, fill them with data, and run some queries against them to see which one performs better. Is there a tool that will…
BenV
  • 4,823
  • 7
  • 37
  • 38
23
votes
6 answers

Is there any good tool for making Database Design and Prototypes?

I would like to have a good tool for designing the Database Schema with all the tables, columns, data types and relations. Today I mostly do this with pen and paper but I would like to do it in a good design tool. Is there any good (and maybe free)…
Jonas
  • 31,495
  • 27
  • 59
  • 64
21
votes
14 answers

Comfortable sqlplus interface?

I found sqlplus'interface is rather outdated. It's quite nice to have some commands or keywords at disposal, but for example no "arrow-up" key for the previous history entry is available. What is a good replacement / extension for sqlplus? Could be…
Sebastian Roth
  • 1,346
  • 3
  • 15
  • 23
21
votes
6 answers

Are there any good and free tools for managing a PostgreSQL database?

Before, I have used phpmyadmin to manage an MySQL database, but now I would like to manage a PostgreSQL database. The PostgreSQL database is on a server, but not a webserver, so I don't use PHP. Are there any good and free tools for managing a…
Jonas
  • 31,495
  • 27
  • 59
  • 64
17
votes
6 answers

Redgate SQL Compare vs Visual Studio 2010 Premium/Ultimate database project

I currently use the Visual Studio Professional Edition which has the database project as a project template, but some of its features are not available, for example Schema Compare tool. The schema comparison and database update scripts generation…
rem
  • 1,525
  • 3
  • 20
  • 22
17
votes
2 answers

Open Source Business Intelligence/DWH solutions

I wonder that this question hasn't already been asked. Google only has very few results for me that don't show a high quality tool What are some Open Source (also free is ok) solutions for Data Warehouses and more specifically Business Intelligence…
DrColossos
  • 6,697
  • 2
  • 31
  • 30
15
votes
4 answers

What's a good tool for visualizing SQL Agent jobs?

I find the built-in MS SQL Studio tools for managing Agent jobs to be a little frustrating. What tools out there have you found helpful? Offhand, there are three things I'd like to see in such a tool: A graphical summary of which jobs ran when,…
Jon of All Trades
  • 5,877
  • 5
  • 44
  • 62
14
votes
4 answers

PostgreSQL designing tool

I am about to design a database which is going to run with PostgreSQL. I am used to the magnificent tool called MySQL Workbench for MySQL database. It is useful and it looks good which I kind of expect from a database designing software. If I am…
Cleankod
  • 515
  • 2
  • 5
  • 9
14
votes
2 answers

Tool to export data with all relational data?

Is there a tool to export data from selected rows in a table with all data stored in other tables in other tables linked by relational design? The purpose is to ease migrations of bits of data between servers for adhoc migrations. I am looking…
James McMahon
  • 243
  • 2
  • 7
13
votes
5 answers

Alternatives to MySQL Workbench

I've been running into some problems with MySQL Workbench that I'm not sure will be able to be fixed (namely, what appears to be an old bug that may have resurfaced), so I'd like to be able to find a good backup to it in the event that I can't use…
Shauna
  • 413
  • 1
  • 5
  • 10
12
votes
1 answer

Query execution time in Oracle SQL Developer

I know I can use set timing on to see how long it took to execute a query after the execution is finished. But is it possible to see current execution duration in Oracle SQL Developer while the query is still running? SQL Server Management Studio as…
Marek Grzenkowicz
  • 1,485
  • 2
  • 18
  • 27
11
votes
4 answers

Are there tools to perform data comparison between two different schemas?

We are migrating our database to a new schema but want to validate the data has been moved correctly. Traditional data comparison tools can compare two databases for differences if the schemas are the same. In our case there have been changes to…
Tony
  • 378
  • 4
  • 18
1
2 3 4 5 6