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: 760

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 55 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 269 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 233 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 63 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 140 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 (2)

 bug with '_' in table name  By macfly on November 24, 2014
database name is 'db_stats'
table name is 'stat_kpi'
>> Error Exception
>> ok when not underscore- it's ok

org.apache.ddlutils.DatabaseOperationException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'db_stats.stat\_kpi' doesn't exist
at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase
 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

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
62

Other Swedish personnummer regexps do not take into account that at Swedish universities, foreigners might get special temporary personnummers with a "P", "T", or "F" instead of the first of the four last numbers.

This code fixes the problem, but does not check the validity of the date, or the last number.

Regex

Istat Code

4.0 mhallam 2014-07-29
169

22.12.0|18.24.C||22.12_D|12.56| 1A.56.1

This pattern match the Italian Istat Ateco Code (Codice Istat) updated to Istat Declaration Ateco 2004

Regex

Longitude Validation

4.0 mhallam 2014-07-29
238

-98.092391

Longitude validation (similiar to Latitude Validation) and inspired by the same code

Regex

Currency 16,3

4.0 mhallam 2014-07-29
73

Currency expression, accepts 4 commas and 4 groups of 3 numbers and 1 number before the first comma, this first number will have to be different from zero. It accepts a number of, two or three decimal. It accepts zero numbers after the point. You can change the number of groups and numbers accespts before and after the point.

Regex

Random email

2.0 scorreia 2014-07-29
171

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
74

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
79

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
131

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
111

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
180

This regular expression not only checks if the postal code is five digits long. The second digit must not be zero, because a postal code like 00123 is invalid.

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
685

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
449

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

Data-Model

D* Demo Model

1.0 ctoum 2010-08-13
787

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1158

Talendshop Demo (Demo Project)


56 ms