I'm now working with a legacy database which is missing, among almost everything you'd expect from a decent SQL relational DB, any documentation or metadata. I can't make changes to the DB schema, except my local test copy, as it exists at many client sites and there's no upgrading procedures. Are there any tools that I can use to build and keep my own meta about the database? I'm looking to keep track of relationships, basic documentation about tables and columns, and references in stored procedures. There's 200+ tables and 3300+ SPs. A base autogeneration would be very helpful, particularly with the SPs. Preferably FOSS and Linux, but I will settle for win just to have something.
Database Meta tools
225 Views Asked by kyle At
1
There are 1 best solutions below
Related Questions in SQL
- Can MVC.NET prevent SQL-injection at razor or controller level?
- SQL server not returning all rows
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Creating a parametrized field name for a SELECT clause
- Combine two rows based on common ID
- Column displays each count
- Slick query for one to optional one (zero or one) relationship
- Aggregate and count in PostgreSQL
- MAX and GROUP BY - SQL
- SQL statement for a tricky 2 table query
- How to create nested selects with sql?
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Best Practice for adding columns to a Table in Oracle database
- SQL FIFO STACK using two tables
- SQL Query - Order by String (which contains number and chars)
Related Questions in RELATIONAL-DATABASE
- Database Design: How should I store user's news preferences in MySQL database?
- Listing specific requirements on Access Database form
- How to have multiple rows reference the same field of a single row?
- Why does SQL standard allow duplicate rows?
- How to implement certain relation between two entities?
- Django- manytomany model relationships
- HSQL (in-memory) dramatically slows down when database grows
- MySQL query to get all (additional) symptoms and diseases
- best way to index from Oracle/relational DB into Elastic search
- Unable to get correct data over several joins
- Database Design Advice for a Social Network App Needed
- Automaticlly attach to pivot table in Laravel 5
- Strange results with HSQL (memory) when running transactional test
- UPDATE after INSERT for potentially multiple rows - not working
- Messaging table performance - Merge from and to id`s into one single field vs separate 2 fields
Related Questions in DATABASE-DESIGN
- Big data with spatial queries/indexing
- Unique hash/index for time interval
- Best practices for creating a huge SQL table
- Database Design: How should I store user's news preferences in MySQL database?
- Is it recommended to use Node.js for an online room booking web application?
- Storing multiple item settings in database
- Which column type for storing the year field in a table with rows of yearly data
- Best way to setup a i8n in a database
- Database normalization for electricity monitoring system
- Database Design: Unique Billing Assocation
- Is it always a bad practice to have circular relationships in your database design
- One column maps to mutiple columns from different table
- Replicating tables within the database
- mysql one translates table vs multiple translate table
- Nosql database design for complex querying
Related Questions in DATABASE-METADATA
- What is the location of Update and Delete constraint values in Sybase IQ?
- Can I change the Fetch Mode in a Resultset from a DatabaseMetaData query?
- How can I get number of columns in Staged File Snowflake
- JDBC with Spring slow metadata fetch Oracle
- Error while trying to test if a specific table exists in a MySQL database using JDBC
- How to Access Metadata Fields of an MS Access Database Programmatically?
- Schemacrawler ignore schema that can't be accessed
- How to determine if a column is unsigned?
- Database Meta tools
- Dbeaver doesn't display metadata from one of our hive instances. How to fix?
- Hive query - Get list of all View Names for given Table Name
- How to retrieve DDL of a postgres table using Java JDBC?
- How do I find the column used in a HASH DISTRIBUTION within Azure Synapse?
- How do I clear an Aurora MySQL 5.6 Table Metadata Lock Wait when there are no locking transactions?
- Need a programatic way to get the names, arguments and return types for SQL Server built-in functions
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Not sure what you mean with "metadata", but I'm pretty happy with Liquibase.
It manages the schema in one (or more) XML files and can reverse engineer an existing database (all major ones supported).
It's Java/JDBC based and runs fine on Linux
The main purposes of Liquibase is to handle upgrades (schema migration) smoothly, so I'm not sure if this exactly what you are looking for.