Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.


tTransferDatabase


  • Author: jpcb
  • Categories: Component
  • First revision date: 2012-01-08
  • Latest revision date: 2014-10-26
  • Compatible with: Data Integration releases 5.0.0, 5.0.1, 5.0.2, 5.1.0, 5.1.1, 5.1.2, 5.1.3, 5.2.0, 5.2.1, 5.2.2, 5.2.3, 5.3.0, 5.3.1, 5.3.2, 5.4.0, 5.4.1, 5.4.2, 5.5.0, 5.5.1, 5.6.0
  • Downloads: 736

About: Allows transfer one database engine to another database engine using the library apache ddlutils.

The component supports the following list of database

*DB2
*Firebird
*HSQLDB
*Interbase
*MaxDB
*MySql
*Oracle
*PostgreSQL
*SQL Server
*Sybase

Source Code:
https://github.com/jpcb/ddlutils
https://github.com/jpcb/transferdatabase
https://github.com/jpcb/tTransferDatabase

Report an Issue:
https://github.com/jpcb/tTransferDatabase/issues

Revision list

expand/collapse all

Revision 1.4 39 Downloads, Released on 2014-10-26
Download revision 1.4

Compatible with: 5.6.0, 5.5.1, 5.5.0, 5.4.2, 5.4.1, 5.4.0, 5.3.2, 5.3.1, 5.3.0, 5.2.3, 5.2.2, 5.2.1, 5.2.0, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

*Bugs fixed
*Other minor improvements

Revision 1.3 266 Downloads, Released on 2012-10-26
Download revision 1.3

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

*Bugs fixed

Revision 1.2 231 Downloads, Released on 2012-03-15
Download revision 1.2

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Changes:

*Bugs fixed

Revision 1.1 61 Downloads, Released on 2012-03-07
Download revision 1.1

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Changes:

* Refactored code
* Check unique index name
* Fixed some common mistakes

Revision 1.0 139 Downloads, Released on 2012-01-08
Download revision 1.0

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Release Version

Reviews (1)

 cool By jjzhou on June 7, 2013
cool
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Regex

Temperature in Celsius

1.0 scorreia 2014-08-18
26

Check that a given number is a valid temperature in Celsius.

Regex

Companies House

4.0 mhallam 2014-07-29
91

This Regular Expression is used to match the Companies House 503 Reference number that is given when a customer places an online order.www.companieshouse.gov.uk

Regex

Bulgaria Vat Number

4.0 mhallam 2014-07-29
77

Vat number for Bulgaria. Formats are
BG123456789
BG1234567890

Regex

Austria VAT Number

4.0 mhallam 2014-07-29
95

mysql

Regex

Complex Australian Phone Number

4.0 mhallam 2014-07-29
96

Australian phone number validator. Accepts all forms of Australian phone numbers in different formats (area code in brackets, no area code, spaces between 2-3 and 6-7th digits, +61 international dialing code). Checks that area codes are valid (when entered).

Regex

Bank Routing Transit Number (RTN)

4.0 mhallam 2014-07-29
90

Ensures a given string matches the basic pattern of a bank routing transit number (RTN), used to identify financial institutions on instruments such as checks. Ensures number is nine digits long and has first two digits that comply with American Bankers Association rules.

Regex

ISBN Checker

4.0 mhallam 2014-07-29
115

Expression to check for a valid ISBN number

Regex

International Passport

4.0 mhallam 2014-07-29
85

? 9 characters made up of a combination of numbers and/or letters. Where less than 9 characters it will be padded out to the right with chevrons (

Regex

UK Vehicle Registration Plate Number Plate

4.0 mhallam 2014-07-29
108

AB12 RCY|||CD07 TES|||S33 GTT|||Y999 FVBab12 rcy|||CD07 TIS|||S34 GTT|||Z999 FVB

UK Vehicle Registration Plate / Number Plate format as specified by the DVLA. Accepts both "Prefix" and "New" style. Allows only valid DVLA number combinations as not all are supported. Registration number must be exactly as is displayed on car, hence all letters must be in uppercase and a space seperating the two sets of characters.

Regex

Swedish Personal Nr (Personnummer)

4.0 mhallam 2014-07-29
119

Simple regex for the Swedish personal number. It's in the form: YYMMDD-xxxx where xxxx is an arbitrary number from 0000-9999.

791231-1234

Version Author Released on Rating Downloads
Export

DStar

1.0 ctoum 2010-08-04
1138

D* Industries Demo Model


55 ms