Start a working area

Features

• You can run any command with -v option, it will show you full log of command execution then.
• You can create and config file .dbignore to ignore some of database objects .dbignore must be placed in repository .dbgit directory.

Lets you exclude any of db objects from the work process. If name of db object will be mathed of regular expression you will write in this file it will be missed by the dbgit. Also, if you will write ! as a first character of row, db object will be processed even if the one was excluded by previous expressions. .dbignore creates automatically when you run dbgit link command. By default .dbignore lets you work with your db user scheme only, and it ignores all table data. You can reconfigure it at any time.

clone

Clone a repository into a new directory

usage: dbgit clone [link] <remote_name> [-h] [-v]
Example:
dbgit clone <link>
-h Show this help
-v Output full log of command execution

init

Create an empty Git repository or reinitialize an existing one

usage: dbgit init [-h] [-v]
Example:
dbgit init
-h Show this help
-v Output full log of command execution

link

Establish connection with database

usage: dbgit link <connection_string> [-h] [-v]
Example:
dbgit link jdbc:oracle:thin:@<SERVER_NAME>:<PORT>:<SID> user=<USER> password=<PASSWORD>
-h Show this help
-v Output full log of command execution

It binds dbgit with a database.

This command creates .dbignore file that makes DBGit ignore all db objects except of user's scheme by default. You can reconfig .dbignore at any time.

synonym

Specifiy synonym for db scheme

usage: dbgit synonym [synonym] [schema] [-d] [-h] [-s] [-v]
Examples:
dbgit synonym <syn> <scheme>
dbgit synonym <synonym> -d
dbgit synonym -s
-d Delete synonym
-h Show this help
-s Show synonyms
-v Output full log of command execution

Will create synonym for database schemes, so you can use simple names if your db scheme has long or hard to writing name.

remote

Let you bind your local repository with remote repository

usage: dbgit remote [command] [<params>...] [-h] [-v]
Examples:
dbgit remote
dbgit remote add rep https://login:password@example.com/rep.git
dbgit remote remove rep
-h Show this help
-v Output full log of command execution

config

Let you configure dbgit. Example:

dbgit config MAX_ROW_COUNT_FETCH=10000

You can configure follow options:

LIMIT_FETCH - if true dbgit will save table data when table has less then specific number of rows
MAX_ROW_COUNT_FETCH - specifiy max number of rows for table to save table data, if LIMIT_FETCH is true
LOG_ROTATE - number of days of log rotation
SCRIPT_ROTATE - number of days of sql files rotation