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

learn more… | top users | synonyms

1
vote
1answer
54 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" ...
0
votes
0answers
26 views

Schema Comparison [closed]

DBAs, I'm in the market for a schema comparison and synchronization tool. I've personally never purchased one and have started looking at the various tools. I'd like to know if anyone has a suite ...
0
votes
1answer
17 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 ...
4
votes
3answers
808 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.
0
votes
2answers
38 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
460 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 ...
6
votes
3answers
871 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 ...
5
votes
4answers
2k views

Are there any free online collaboration database schema tools? [closed]

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?
7
votes
6answers
5k views

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

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 ...
186
votes
6answers
322k 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 ...
3
votes
0answers
70 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 ' ...
8
votes
4answers
4k 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 ...
8
votes
6answers
10k 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
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.
5
votes
2answers
1k 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 ...
6
votes
4answers
3k 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 ...
29
votes
7answers
8k 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 ...
27
votes
9answers
9k views

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 ...
2
votes
4answers
555 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..
2
votes
0answers
101 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 ...
14
votes
6answers
5k 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 ...
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.
23
votes
8answers
8k views

Tool to generate large datasets of test data [closed]

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 ...
1
vote
1answer
73 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
2answers
606 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 ...
4
votes
2answers
316 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 ...
15
votes
12answers
3k views

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 ...
2
votes
1answer
566 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 ...
8
votes
5answers
3k 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 ...
0
votes
1answer
133 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. ...
10
votes
4answers
4k 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
2answers
164 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.
2
votes
2answers
6k 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
228 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 ...
1
vote
1answer
209 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
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
0answers
253 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
97 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. ...
4
votes
2answers
265 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
1answer
7k 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 ...
0
votes
1answer
428 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 ...
2
votes
1answer
160 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
10k 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 ...
9
votes
3answers
1k 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
1k views

Named Parameters in SQuirreL SQL?

Is it possible to set named-parameters in queries SQuirreL SQL?
0
votes
0answers
297 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 ...
7
votes
6answers
998 views

Alternative Database Tools for Web Admin

I currently use phpmyadmin for most of my database administration. It works well enough, but I'm interested in other tools that might work more quickly/efficiently/etc... What are the best and/or ...
0
votes
3answers
494 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 ...
2
votes
2answers
5k views

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

What are the free and commercial tools available for Sybase Database?
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 ...