CVS log for scripts/perl/oracle/oracledump.pl

Up to [Platon] / scripts / perl / oracle

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.36 / (download) - [select for diffs], Sat Aug 23 20:48:06 2008 UTC (18 years, 1 month ago) by nepto


Changes since 1.35: +3 -3 lines
Diff to previous 1.35 (colored) to selected 1.19 (colored)

Comments removed from default value

Revision 1.35 / (download) - [select for diffs], Sat Aug 23 20:40:12 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.34: +21 -3 lines
Diff to previous 1.34 (colored) to selected 1.19 (colored)

Table data record count information added

Revision 1.34 / (download) - [select for diffs], Sat Aug 23 19:21:26 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.33: +12 -8 lines
Diff to previous 1.33 (colored) to selected 1.19 (colored)

Ignore datatype AQ$_SUBSCRIBERS
Ignore default value UID
Better handling of RAW datatype

Revision 1.33 / (download) - [select for diffs], Sat Aug 23 18:54:00 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.32: +3 -3 lines
Diff to previous 1.32 (colored) to selected 1.19 (colored)

Fixed MySQL error: BLOB/TEXT column can't have a default value

Revision 1.32 / (download) - [select for diffs], Sat Aug 23 18:45:25 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.31: +3 -3 lines
Diff to previous 1.31 (colored) to selected 1.19 (colored)

Increased LongReadLen to 5000000

Revision 1.31 / (download) - [select for diffs], Sat Aug 23 18:44:21 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.30: +3 -3 lines
Diff to previous 1.30 (colored) to selected 1.19 (colored)

Added TIMESTAMP(6) into escape_data()

Revision 1.30 / (download) - [select for diffs], Sat Aug 23 14:38:14 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.29: +4 -29 lines
Diff to previous 1.29 (colored) to selected 1.19 (colored)

Column names routine joined with column types routine

Revision 1.29 / (download) - [select for diffs], Sat Aug 23 14:36:41 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.28: +11 -7 lines
Diff to previous 1.28 (colored) to selected 1.19 (colored)

Better string quoting (warning: \x00 is changed to SPACE, \x00 cannot be
in input, since `mysql' client binary handles is wrong way)
Comma (,) is changed to point (.) for numeric values

Revision 1.28 / (download) - [select for diffs], Sat Aug 23 14:35:06 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.27: +7 -5 lines
Diff to previous 1.27 (colored) to selected 1.19 (colored)

Ignoring some weird default values such as to_date(), USER, etc.
Switch some weird datatypes (NVARCHAR2, RAW, etc.) to VARCHAR or BLOB

Revision 1.27 / (download) - [select for diffs], Sat Aug 23 14:32:02 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.26: +6 -4 lines
Diff to previous 1.26 (colored) to selected 1.19 (colored)

XMLTYPE datatype ignored

Revision 1.26 / (download) - [select for diffs], Sat Aug 23 14:22:41 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.25: +3 -3 lines
Diff to previous 1.25 (colored) to selected 1.19 (colored)

MySQL table handler defined and charset

Revision 1.25 / (download) - [select for diffs], Sat Aug 23 14:21:25 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.24: +3 -2 lines
Diff to previous 1.24 (colored) to selected 1.19 (colored)

Setting up NLS_LANG enviroment

Revision 1.24 / (download) - [select for diffs], Sat Aug 23 14:18:52 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.23: +4 -4 lines
Diff to previous 1.23 (colored) to selected 1.19 (colored)

LongReadLen increased to 999999

Revision 1.23 / (download) - [select for diffs], Thu Aug 21 08:25:11 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.22: +3 -3 lines
Diff to previous 1.22 (colored) to selected 1.19 (colored)

TIMESTAMP added to escape_data()

Revision 1.22 / (download) - [select for diffs], Thu Aug 21 08:23:48 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.21: +3 -2 lines
Diff to previous 1.21 (colored) to selected 1.19 (colored)

LongReadLen initialized to 50000 to prevent BLOB related warnings

Revision 1.21 / (download) - [select for diffs], Thu Aug 21 08:22:43 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.20: +4 -4 lines
Diff to previous 1.20 (colored) to selected 1.19 (colored)

Column names in Oracle are quoted
(fixed problems with column containing dash in names)

Revision 1.20 / (download) - [select for diffs], Wed Aug 20 13:44:51 2008 UTC (18 years, 1 month ago) by nepto

Changes since 1.19: +13 -9 lines
Diff to previous 1.19 (colored)

Several fixes:
    - V$INSTANCE.HOST_NAME ignored if not available
    - table name prefixed with owner (if defined)
    - NVARCHAR2 datatype added
    - escape backslash in strings

Quoting table name for MySQL

Revision 1.18 / (download) - [select for diffs], Tue Mar 27 16:57:32 2007 UTC (19 years, 6 months ago) by nepto

Changes since 1.17: +4 -4 lines
Diff to previous 1.17 (colored) to selected 1.19 (colored)

Escape also CLOB

Revision 1.17 / (download) - [select for diffs], Tue Mar 27 16:26:41 2007 UTC (19 years, 6 months ago) by nepto

Changes since 1.16: +15 -7 lines
Diff to previous 1.16 (colored) to selected 1.19 (colored)

Changed CLOB to BLOB
Fixed DEFAULT NULL for NOT NULL columns

Revision 1.16 / (download) - [select for diffs], Sun Mar 18 04:25:38 2007 UTC (19 years, 7 months ago) by nepto

Changes since 1.15: +10 -4 lines
Diff to previous 1.15 (colored) to selected 1.19 (colored)

Quoting column names for MySQL

Revision 1.15 / (download) - [select for diffs], Sat Mar 17 07:27:43 2007 UTC (19 years, 7 months ago) by nepto

Changes since 1.14: +10 -13 lines
Diff to previous 1.14 (colored) to selected 1.19 (colored)

Fixed that stupid Perl/DBI "Illegal instruction" when using
$dbh->prepare() with variable arguments

Revision 1.14 / (download) - [select for diffs], Sat Mar 17 06:47:38 2007 UTC (19 years, 7 months ago) by nepto

Changes since 1.13: +12 -2 lines
Diff to previous 1.13 (colored) to selected 1.19 (colored)

Checking for user/pass@database implemented

Revision 1.13 / (download) - [select for diffs], Sat Apr 30 13:52:17 2005 UTC (21 years, 5 months ago) by nepto

Changes since 1.12: +4 -14 lines
Diff to previous 1.12 (colored) to selected 1.19 (colored)

Return exit code values improved.

Revision 1.12 / (download) - [select for diffs], Sun Feb 15 18:58:20 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.11: +3 -3 lines
Diff to previous 1.11 (colored) to selected 1.19 (colored)

Proper DEFAULT SYSDATE handling.

Revision 1.11 / (download) - [select for diffs], Fri Jan 23 18:38:20 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.10: +62 -22 lines
Diff to previous 1.10 (colored) to selected 1.19 (colored)

Added ability to define an owner of tables, when doing query for table
names and/or table columns (new --owner=# command line option).

Revision 1.10 / (download) - [select for diffs], Fri Jan 23 14:12:42 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.9: +4 -4 lines
Diff to previous 1.9 (colored) to selected 1.19 (colored)

Added one mandatory space between field name and its type
(this was causing problems, when field name was too long)

Revision 1.9 / (download) - [select for diffs], Fri Jan 23 14:09:08 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.8: +25 -13 lines
Diff to previous 1.8 (colored) to selected 1.19 (colored)

Table names are always uppercase when querying Oracle database.
Table names are always lower cases when doing MySQL compliant dump.
DROP TABLE clause gets IF EXISTS during MySQL compliant dump.

Revision 1.8 / (download) - [select for diffs], Fri Jan 23 13:54:52 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.7: +11 -5 lines
Diff to previous 1.7 (colored) to selected 1.19 (colored)

Improved support for MySQL DECIMAL and INT datatypes.

Revision 1.7 / (download) - [select for diffs], Thu Jan 22 22:01:37 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.6: +3 -3 lines
Diff to previous 1.6 (colored) to selected 1.19 (colored)

Added general support for CHAR column types.

Revision 1.6 / (download) - [select for diffs], Thu Jan 22 21:45:20 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.5: +3 -3 lines
Diff to previous 1.5 (colored) to selected 1.19 (colored)

Converts DATE to DATETIME when doing MySQL compliant dump.

Revision 1.5 / (download) - [select for diffs], Thu Jan 22 21:29:44 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.4: +15 -28 lines
Diff to previous 1.4 (colored) to selected 1.19 (colored)

Fixed bug when undefined numeric value was not written as ''.
Data escape routine reformatted.

Revision 1.4 / (download) - [select for diffs], Thu Jan 22 21:03:21 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.3: +66 -21 lines
Diff to previous 1.3 (colored) to selected 1.19 (colored)

Added support for MySQL compliant SQL dump
(new --mysql-compliant-dump option)

Revision 1.3 / (download) - [select for diffs], Thu Jan 22 20:40:06 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.2: +5 -5 lines
Diff to previous 1.2 (colored) to selected 1.19 (colored)

Prompt for username and password is printed to STDERR now.

Revision 1.2 / (download) - [select for diffs], Thu Jan 22 20:38:13 2004 UTC (22 years, 8 months ago) by nepto

Changes since 1.1: +3 -1 lines
Diff to previous 1.1 (colored) to selected 1.19 (colored)

Added $Platon$ tag.

Revision 1.1 / (download) - [select for diffs], Thu Jan 22 20:37:32 2004 UTC (22 years, 8 months ago) by nepto

Diff to selected 1.19 (colored)

Oracle SQL dump utility (oracledump) imported into CVS.

Current version is 0.09.

Copyright (C) 1999 David Kilzer.

This library is free software; you can redistribute it and/or
modify it under the same terms as Perl itself.

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.