SQLOBJECT-ADMIN(1) General Commands Manual SQLOBJECT-ADMIN(1)NAME
sqlobject-admin - manage your database as defined with SQLObject classes
SYNOPSIS
sqlobject-admin [options] command
DESCRIPTION
The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes.
Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the
database to match the version of the schema in your code.
COMMANDS
The following commands are recognized:
help
Show the help text.
create
Find the tables and create them. Existing tables are simply skipped.
sql
Show the SQL to create all the tables.
drop
Drop tables. Missing tables are skipped.
execute
Execute an arbitrary SQL expression.
list
List out all the found classes.
status
Show if tables are present in the database.
record
Record historical information about the database status
upgrade
Update the database to a new version (as created by record)
OPTIONS -c CONNECTION, --connection=CONNECTION
Connection string for the database .
-f FILENAME, --config-file=FILENAME
Configuration file from which to get the connection to the database.
-m MODULE, --module=MODULE
A module to look in for classes.
-p PACKAGE, --package=PACKAGE
A package to look in.
--class=CLASSMATCH
Restricting the found classes to the matching classes.
--egg=EGG_SPEC
Egg description that should be loaded.
AUTHORS
This manual page was written by Carl Chenet <chaica@ohmytux.com>.
LICENSE
This package is licensed under the GNU Lesser General Public License. You can
find the full text of the LGPL in /usr/share/common-licenses/LGPL in your
Debian system.
06/03/2010 SQLOBJECT-ADMIN(1)
Check Out this Related Man Page
MDBTools(1)MDBTools(1)NAME
mdb-tables - Get listing of tables in an MDB database
SYNOPSIS
mdb-tables [-S] [-1 | -d delimiter] database
DESCRIPTION
mdb-tables is a utility program distributed with MDB Tools.
It produces a list of tables contained within an MDB database in a format suitable for use in shell scripts.
OPTIONS -S Show system tables. System tables are generally those beginning with 'MSys'
-1 specifies that the tables should be listed 1 per line.
-d delimiter
specifies an alternative delimiter. If no delimiter is specified, table names will be delimited by a tab character, or by newline if
the -1 option was specified.
NOTES ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
HISTORY
mdb-tables first appeared in MDB Tools 0.3.
SEE ALSO gmdb2(1)mdb-export(1)mdb-hexdump(1)mdb-prop(1)mdb-sql(1)mdb-ver(1)mdb-array(1)mdb-header(1)mdb-parsecsv(1)mdb-schema(1)AUTHORS
The mdb-tables utility was written by Brian Bruns.
BUGS
Access allows for tables to have spaces embeded in the table name.
You must specify a delimiter (-d) if you intend on piping the output of mdb-tables to a program such as awk or cut.
0.7 13 July 2013 MDBTools(1)
I have completely blanked out on this and I have done it a million times. I need to modify some tables in unix. What is the command for opening/viewing the tables?
Thanks so much. :o (2 Replies)
I want to collect the database tables(Ex: Emp,Sal,Bonus...etc)
in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ?
Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log
i want to change this into
Ex:- Import... (3 Replies)
I have to read one input file which will give me some tables info like TradeNo,MsgId,status etc...
I have read that TradeNo from that input file and then look for that trade no in the database table and in the database I have to update the columns for that particular trade which I am getting fron... (7 Replies)
Hi all^^
after upgrade joomla (1.5.7-1.5.11) this package , and then
portaudit -Fda
fetch: http://www.FreeBsd.org/ports/auditfile.tbz: No address record
Couldn't fetch database.
Old database restored.
portaudit: Download failed
what wrong??? (1 Reply)
Hi
I am trying to write a script to extract information from a database and save that info to a csv file.
I am using sql, an oracle database
I have no idea how to even begin this.
Can somebody please help. (8 Replies)
Hi experts,
I'm looking for a specific DB admin tool.
I'm not looking for complicated BPM(business process management) software,
what I need is just some additional functionality embedded within DB admin tool.
What I need is the
1.Approvement system - whenever there is a... (4 Replies)
Hi,
I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large... (5 Replies)
dear all
please help me !
i need a script for exporting the selected tables of oracle database installed on CentOs.
i waiting your response.
thanks and regards (6 Replies)
HI Team
I have q tricky question when joining 3 tables in Teradata DB.In the last line of my query , I am comparing one condition with C an B tables and its creating performance issue in returning the data . Basically I want to eliminate OR clause and try other approach.Is there any logic to... (3 Replies)
Hi Guys,
Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? (10 Replies)