SchemaCrawler 5.4 (Default branch)


 
Thread Tools Search this Thread
Special Forums News, Links, Events and Announcements Software Releases - RSS News SchemaCrawler 5.4 (Default branch)
# 1  
Old 02-05-2008
SchemaCrawler 5.4 (Default branch)

SchemaCrawler is a platform (OS and database) independent command line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is also an API that improves on standard JDBC metadata. License: GNU Lesser General Public License (LGPL) Changes:
This release provides JDBC driver metadata, including driver properties. A new command line switch, -schemapattern, is available for specifying schema patterns when a connection is specified from the command line. Object attributes are added automatically from unused columns in the metadata calls.Image

More...
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question
DBICADMIN(1p)						User Contributed Perl Documentation					     DBICADMIN(1p)

NAME
dbicadmin - utility for administrating DBIx::Class schemata SYNOPSIS
dbicadmin: [-I] [long options...] deploy a schema to a database dbicadmin --schema=MyApp::Schema --connect='["dbi:SQLite:my.db", "", ""]' --deploy update an existing record dbicadmin --schema=MyApp::Schema --class=Employee --connect='["dbi:SQLite:my.db", "", ""]' --op=update --set='{ "name": "New_Employee" }' OPTIONS
Actions --create Create version diffs needs preversion --upgrade Upgrade the database to the current schema --install Install the schema version tables to an existing database --deploy Deploy the schema to the database --select Select data from the schema --insert Insert data into the schema --update Update data in the schema --delete Delete data from the schema --op compatiblity option all of the above can be suppied as --op=<action> --help display this help Arguments --schema-class The class of the schema to load --resultset or --resultset-class or --class The resultset to operate on for data manipulation --config-stanza Where in the config to find the connection_info, supply in form MyApp::Model::DB --config Supply the config file for parsing by Config::Any --connect-info Supply the connect info as additional options ie -I dsn=<dsn> user=<user> password=<pass> --connect Supply the connect info as a json string --sql-dir The directory where sql diffs will be created --sql-type The RDBMs flavour you wish to use --version Supply a version install --preversion The previous version to diff against --set JSON data used to perform data operations --attrs JSON string to be used for the second argument for search --where JSON string to be used for the where clause of search --force Be forceful with some operations --trace Turn on DBIx::Class trace output --quiet Be less verbose -I Same as perl's -I, prepended to current @INC AUTHORS
See "CONTRIBUTORS" in DBIx::Class LICENSE
You may distribute this code under the same terms as Perl itself perl v5.14.2 2011-11-29 DBICADMIN(1p)