Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [tools]

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

1
vote
0answers
17 views

Which PgBackRest policy for differential backups in PostgreSQL

I set up pgBackRest and PostgreSQL configuration in two differents servers. I set up with crontab one full backup a week and one differential backup a day. 0 1 * * 0 pgbackrest --type=...
1
vote
3answers
55 views

Long/complex INSERT and UPDATE query parser or visual editor/query builder [closed]

I have long INSERT queries that insert values to table with over 50 columns. Is there any tool to parse this long query to key-value representation? like: INSERT INTO sometable(col1, col2, col3) ...
0
votes
1answer
13 views

Setting model title in MySQL Workbench for Forward Engineering

In MySQL Workbench, when viewing a model, you can select File->Export->Forward Engineer SQL Create Script. The first four lines of the generated file are a comment, something like this: -- ...
3
votes
1answer
23 views

When creating a database using an ERD, what do the entities and relationships become (in database terms)?

MIS student, here. Learning about ERDs (entity relationship diagrams). ERDs are supposedly used for the purpose of later constructing a database. My question is this: What will an entity (and, ...
0
votes
1answer
165 views

Entity-Relationship Diagram Software [closed]

I saw this E-R diagram in an answer on Stack Overflow: Does anyone know which software was used to create it? I use LucidChart but that output is really nice!
1
vote
3answers
1k views

How can I use Invoke-SqlCmd with variables to output the SQL command only or some similar method?

I have a big *.sql file that I run with Invoke-Sqlcmd and variables to do some tasks, and when I have an issue, it's a pain to debug because of the variables and I want to do logging of the SQL script ...
1
vote
1answer
49 views

Tools to use SQL Server is down [closed]

I have to go to multiple locations like SQL error log file, Event Log, run sp_whoisactive whenever I am have escalations from customers that SQL Server is slow. Is there any tool that will quickly ...
2
votes
2answers
349 views

MySQL: optimize column size

I need a tool/command which will check a table then say something like that: columnA use tinyint instead of int columnB use enum instead of varchar I've seen something like this while ago so I do ...
4
votes
1answer
294 views

Revision Tracking & Source Control for Azure SQL Data Warehouse

What is a good approaching for tracking incremental changes to database tables, stored procedures, etc for Azure SQL Data Warehouse? I am in the process of moving a large database over to Azure SQL ...
0
votes
1answer
15 views

Why does “DB2 Recovery Expert” web console doesn't enable the Run and Next button?

Sometimes, when performing the Log Analysis and Recovery options in the Recovery Expert web console, the buttons "Next" and/or "Run" aren't enabled. This is strange because we do provide all the ...
1
vote
0answers
84 views

I am using Db2 Recovery Expert and having error with adding Managed Databases

I have Db2 11.1 installed in my windows machine and created a Linux 32 bit in my virtualbox (unfortunately my intel doesn't allow me to change the virtualization method..anyway). I installed ...
10
votes
2answers
3k views

Are these tools still valid?

I was watching a 7 years old webinar done by Brent Ozar (https://youtu.be/U_Kle3gKaHc), and heard of several items being recommended at that time. SQLDiag utility. SQLNexus. PAL tool. Database ...
1
vote
3answers
99 views

How to track only the tables used by app

I have a very messed up database with lot of tables that are really not used by the app so I'm tracking all the used tables with the general_log. I'm making the request to the app and with tail -f /...
0
votes
0answers
33 views

Tool to administer Postgres user rights?

I think it is incredibly tedious to administer user rights in Postgres. If I for example want to give editing access to an updatable view, then I need to ensure that the user has the right accesses to,...
1
vote
1answer
218 views

Is common_schema safe?

I just ran across common_schema, a utility for MySQL database administrators. It is a SQL script that creates a schema called common_schema in your database and plenty of stored procedures. I need it ...
5
votes
1answer
199 views

Anemometer - query on analysing the slow logs

I'm new to SQL anemometer. I need to know whether this tool would be able to query to the source database and analyze the slow query logs on real time or not?
2
votes
1answer
431 views

Run sp_BlitzCache an agent job to assist performance tuning efforts / baselining query performance?

Just getting into using various Brent Ozar tools like sp_BlitzCache and sp_BlitzIndex to identify and correct SQL Server performance issues. Been experimenting with running sp_AskBrent (now BlitzFirst....
0
votes
2answers
2k views

Open Source tools to visualise MySQL/MariaDB performance metrics (show global status with intervall)

I search for an Open Source tool to visualise MySQL/MariaDB performance metrics (output of show global status in nice graphs). In MongoDB world there is the Closed Source Ops Manager and the Open ...
1
vote
1answer
343 views

First Response Kit is missing sp_AskBrent

I just downloaded the First Responder kit. Unfortunately, the 'sp_AskBrent' was not included in the download. How can I get it to complete the kit?
1
vote
1answer
51 views

Is there a UI tool for moving data from two different tables?

The schemas in the two databases are different. Eg. Database 1 / users - id - name - phone Database 2 / users - id - first_name - mobile Is there a tool that lets me visually create the statements ...
0
votes
1answer
314 views

HeidiSQL solution for SQL Server error 18488?

I'm connecting to a remote database using HeidiSQL client but looks like the administrator has activated the enforce password change policy (Error 18488). Is there a workaround to solve this with ...
2
votes
2answers
520 views

Squirel SQL uses wrong command for MySQL when renaming a column

I installed Squirel SQL on Ubuntu and a downloaded and put a MySQL driver into the lib folder of the Squirel folder. Then I chose this driver in the "extra class" tab when configuring Squirel MySQL ...
1
vote
1answer
564 views

Compare data between 2 different schemas

We refactored our old database. Some tables were dropped, some tables were split into 2 new tables etc. So now we have an absolutely new DB schema which has many differences from the old one. Someone ...
1
vote
1answer
2k views

Couchbase GUI for exploring data

Is there GUI for Couchbase to explore data (especially views), similar to PGAdmin 3 or MySQL Workbench or RoboMongo EDIT: ah, I found the button mentioned by this link
2
votes
1answer
12k views

What's a good workbench tool for sqlite similar to MySQLWorkbench for MySQL? [closed]

What's a good workbench tool for sqlite similar to MySQLWorkbench for MySQL? I'm used to MySQLWorkbench for working with MySQL databases. Now I have some sqlite databases to work with and would ...
0
votes
2answers
731 views

Which tool enables using SQL query result sets as temporary tables for further analysis and set operations? [closed]

For examples, lets say I need to do set operations and joins on below 3 result sets. I don't want to write a composite query or use temporary database tables. Something which would enable faster data ...
0
votes
0answers
4k views

Generating an ER Diagram from SQL CREATE TABLE statements

As I can't find any ER diagram feature built in with Apex, I want to create one with the SQL statements I executed in order to set up the tables in my Apex Workbench. I found schemaSpy, which is ...
3
votes
1answer
134 views

sqlfiddle: leading blanks are gone [closed]

I am not sure if this is on topic here. When selecting VARCHAR2 columns that contain values with leading blanks this leading blanks will not be displayed in the output of sqlfiddle. so select ' ...
1
vote
1answer
142 views

Text-based interface for PostgreSQL?

I know that psql is an option, but I'm looking for an easier text-based interface for PostgreSQL. Something that's similar to what 'tig' is to 'git', or 'phpmyadmin' is to 'mysql' (but using the ...
2
votes
1answer
2k views

Convert Oracle database to Derby

I need to migrate an existing Oracle Database into a Derby one. I want to know if there's a tool, a script or another way to do that work. It is using any of the interesting features of Oracle, as I ...
0
votes
1answer
534 views

Tool to view intermediate query results

I am using SQL Server 2008 Express edition and I've worked two days on a problem where seems to be a cross join in running a query. I would want to know the set returned per join operation visually. ...
11
votes
2answers
6k views

Tool to export data with all relational data? [closed]

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 ...
3
votes
1answer
489 views

Microsoft Baseline Configuration Analyser on Production

I came across an useful tool that Microsoft has released for configuration analysis. It's called Microsoft Baseline Configuration Analyser 2.0. I downloaded and ran it on my local instance and got a ...
4
votes
2answers
1k views

Open source and commercial tools to build dynamic queries of fact tables in star schema [closed]

What user interfaces or tools (commercial and/or open source) can query a star schema model (Ralph Kimball dimensional model)? So for example, if we have X fact tables, and Y dimension tables, and Z ...
1
vote
1answer
212 views

Monitor Sql Server 2000

I was wondering if there is a free tool to monitor state of SQL Server 2000. I would prefer a web tool. I would like to see if some database is accessible, or are there any problems on server, etc. ...
6
votes
2answers
810 views

What are my options for GUI based Administration & Management of PostgreSQL

I have been given the task of working with PostgreSQL 9.1. I have previously worked with Microsoft SQL, and had used the SQL Management Studio. I had used Oracle's SQL developer as well as TOAD when I ...
5
votes
3answers
2k views

Are there any tools to go from ERD to DB design and vice versa? [closed]

I'm learning DB design and looking for some tools, preferably open source software, that could help go from an ERD to a DATABASE and vice versa. For the record, the database i'm using is MySQL.
1
vote
1answer
126 views

Is there a way to create a re-usable base table definition in InfoSphere Data Architect?

Our company has chose to use IBM's InfoSphere Data Architect (IDA) for data architecting regarding our data warehouse and data marts. The data architects originally designed several "re-usable" ...
2
votes
1answer
348 views

Good tool for simulating many threads doing INSERTS UPDATES SELECTS and DELETES on an ODBC database?

I've done load testing on a web application already using tools like JMeter, and tested my database for transactional integrity. But are there any tools for testing an ODBC connected database (like ...
2
votes
1answer
25k views

Oracle DBCA utility: “Listener is not up or database service is not registered with it”

I'm a software engineer with some experience on SQL Server but a newbie on Oracle. I'm attempting to run dbca on a remote linux machine to reconfigure a database that was initially configured to idle ...
7
votes
2answers
6k views

free database modelling software [closed]

What is available in the realms of database modelling software that is free. I am developing an SQLExpress database. CA ERWin - community version although is free, I can't see an option to allow ...
11
votes
3answers
4k views

How to control the order of servers listed in the SSMS connection dialog?

My current project involves a lot of database shuffling as we upgrade from SQL 2008 -> 2012, re-task hardware, repeat. One minor annoyance is the connection dialog in SSMS re-shuffling the server ...
2
votes
1answer
6k views

Named Parameters in SQuirreL SQL?

Is it possible to set named-parameters in queries SQuirreL SQL?
3
votes
4answers
11k views

Are there alternatives to the TOAD tool for SQL Server? [closed]

Are there any great tools as an alternative TOAD to be used for SQL Server? The tool can be commerical or open source.
13
votes
5answers
12k views

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

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 ...
0
votes
3answers
644 views

Is any tool for taking MySQL Dump Automatically with a particular time? [closed]

I am using VS2010 and MySQL for my project. My client wantw to take mysqldump every day like a daily backup. I want to give my client a tool for taking mysqldumps on a particular time schedule. Do ...
0
votes
1answer
587 views

Extracting Extended Entity Relationship Diagram from a Relational Database

I am researching how to extract an Extended Entity Relationship (EER) diagram from a Relational Database. I'm using Visual Studio 2010 and SQL Server 2008. I've found tools for Entity Relationship ...
1
vote
4answers
1k views

MySQL Replication monitoring [closed]

Im looking for a tool that could help me and my team monitor our MySQL Replication. I would love for a tool that could alert me if Seconds_Behind_Master passes a threshold Slave_SQL_running is false ...
4
votes
2answers
23k views

What Query Browser tools are out there available for Sybase Database? [closed]

What are the free and commercial tools available for Sybase Database?
1
vote
1answer
9k views

Differences with using Bind variables in TOAD,sqlplus and SqlDeveloper

I have following example query. variable pStartDateBegin VARCHAR2(10); variable pEndDateFinish VARCHAR2(10); begin select '01-01-2000', '30-11-2011' into :pStartDateBegin,:...