Questions about any and all tools related to databases or the job of database administration.
1
vote
1answer
66 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 ...
1
vote
0answers
121 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
0answers
31 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
75 views
Evaluation of end user reporting tools and capabilities
I tried to find a reliable software review that compares the Reporting tools which provide end users to create their own reports. However couldn't find any. The reviews were either too old, or they ...
0
votes
0answers
22 views
Missing add source menu after installing jdbcunity multi-source plugin for SQuirelL SQL?
I was following the installation instructions for the jdbcunity multi-source plugin for SQuirelL SQL and it states that after I install it and set it up as a datasource, I should be able to see the ...
0
votes
0answers
50 views
Comparing Sqlite databases
I would like to compare Sqlite databases with each other, both schema and data. I know that a rather crude method exists by comparing the database dumps with each other. But are there any other ...
0
votes
0answers
706 views
Generating an ER diagram with relationships from an MySQL MyISAM database?
Are they any tools to extract out the relationships in a MyISAM database into an ER diagram?
I understand that MyISAM doesn't have foreign keys, but the columns in my database that represent foreign ...
0
votes
0answers
150 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 ...
