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

learn more… | top users | synonyms

3
votes
0answers
68 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 ' ...
2
votes
0answers
73 views

Tool to visualize data differences between two DB tables [closed]

I work as a tester. I found some of the defects I investigate can be traced down to differences in configuration between local and customer's environments. As the tested system has major part of ...
1
vote
1answer
70 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 ...
1
vote
1answer
373 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
113 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. ...
2
votes
2answers
329 views

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 ...
2
votes
1answer
198 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
270 views

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

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
0answers
215 views

PeopleSoft or Oracle App Designer Tool Alternative

We are using PeopleSoft app designer tool to manage and create projects, database objects - tables, columns, views etc in Oracle database. This tool has limitation that we cannot create tables/columns ...
1
vote
1answer
91 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. ...
3
votes
2answers
209 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 ...
4
votes
2answers
700 views

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

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
106 views

Expanding contractions/number ranges into separate records [closed]

I am planning the migration of a directory of image files plus a FileMaker-database containing the corresponding metadata into an Imagic IMS database (formerly known as ImageAccess). The vendor ...
1
vote
1answer
166 views

Database comparison tool for IBM db2 like OPatch?

I am looking for a database comparison tool for IBM DB2. I was wondering if there is a utility for IBM DB2 similar to OPatch in Oracle's db 11g?
1
vote
1answer
46 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
142 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 ...
1
vote
1answer
8k 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 ...
5
votes
2answers
810 views

free database modelling software

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 ...
9
votes
3answers
826 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
787 views

Named Parameters in SQuirreL SQL?

Is it possible to set named-parameters in queries SQuirreL SQL?
3
votes
5answers
3k 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.
0
votes
0answers
241 views

oracle sql dependency extractor

Is there a tool which given a bunch of data extraction SQL scripts will produce a dependency graph? Basically given scripts which take input tables, create a bunch of interdependent intermediary ...
5
votes
4answers
2k views

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

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

I am using VS2010 and MySQL for my project. My Client want to take MySQL Dump Every Day like Daily Backup. So I want to give a tool for Taking MySQL Dump with a particular time. Do you know any tool ...
5
votes
7answers
2k views

Recommended tools for SQL Server Developers & DBA [closed]

I was thinking what tools are recommended for SQL Server Developer & DBAs? The list can comprise of free & paid tools which could be helpful to any SQL Server Guy (Developer/DBA). The tool ...
0
votes
1answer
402 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
5answers
673 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 ...
2
votes
2answers
4k views

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

What are the free and commercial tools available for Sybase Database?
1
vote
1answer
3k 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 ...
2
votes
2answers
542 views

Logical schema development and migration tool for different physical schema available including triggers and stored procedures?

We are planning to support for our application another rdbms (oracle). At the moment we are design our database schema with the MySQL-Workbench. For every new database version we have schema ...
3
votes
2answers
163 views

Could someone recommend a db management tool that supports SQLite, MySQL, PostgreSQL, and is web-based?

Could someone recommend a db management tool that supports SQLite, MySQL, PostgreSQL, and is web-based? By 'web-based' I just mean it can be run in a browser locally or remotely.
29
votes
7answers
7k views

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 ...
4
votes
4answers
2k views

Are there any free online collaboration database schema tools?

I am interested in a free and simple MySQL tool which can offer online collaboration functionality in creating database general schema. Do you know any?
8
votes
4answers
3k views

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 ...
2
votes
4answers
491 views

Tool to monitor database data

I would like to tool that when record data changed inside all tables. so later i would get a report like table user added record - 3,user3.. deleted record - 2,user2..
4
votes
3answers
427 views

What are the 'free to use' workload generators available for Oracle?

A couple that I know about are http://www.dominicgiles.com/swingbench.html and http://hammerora.sourceforge.net/ Are there any others? I am looking for tools what can generate random workload ...
8
votes
6answers
9k views

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 ...
2
votes
2answers
5k views

Which business intelligence tool is better for use with a PostgreSQL database?

I'm trying to find a good BI tool which can be connected to a PostgreSQL database. I need the following abilities: Reporting Services Dashboards OLAP Data Mining. The BI server should work on ...
2
votes
1answer
1k views

Tool to Convert MySQL DB to MS SQL 2005 (Especially stored procedures)

Is there any tool to convert MySql db to MS SQL 2005. I am mostly interested in converting Stored Procedures. There are 100s of procedures and writing them again in T-SQL is a big job. Thanks.
4
votes
2answers
2k views

“phpMyAdmin” for Cassandra

Is there a tool like phpMyAdmin for RDBMS-MySQL for a Cassandra DB? I know that there is less "runtime" config possible (column families can not be edited at runtime etc.). Nevertheless, it would be ...
8
votes
5answers
2k views

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 ...
5
votes
2answers
706 views

DB2 passwords with special characters

Our DB2 authentication is integrated with active directory, so the allowed passwords are controlled by it's policy. We have some users that are not being able to connect to the database through ...
4
votes
1answer
6k views

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 ...
10
votes
4answers
3k views

Tools to migrate from SQLite to PostgreSQL

I need to continuously migrate from SQLite to PostgreSQL. By continuously, I mean that I will reimport the SQLite database into PostgreSQL every day. It would be nice if I could make changes to the ...
3
votes
1answer
67 views

Database appearing in one tool but not another

Can anyone think of a reason why a mySQL database would be accessible from one tool (phpMyAdmin, logged in as db_user) but not from another (Sequel Pro, logged in as db_user). The user is the same in ...
10
votes
5answers
3k views

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 ...
6
votes
6answers
3k views

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 ...
13
votes
2answers
2k views

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 ...
136
votes
6answers
231k views

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 ...
13
votes
6answers
4k views

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 ...