2007/05/29

dbput data transfer 3.1

DBPut data transfer 3.1

Converting data between different databases.

DBPut data transfer is a creative and advanced software used for converting data between different databases. such as: MySQL, Oracle, DB2, Microsoft SQL Server Sybase, Access, dBase, Paradox, Foxpro, Text etc. With the DBPut data transfer transferring and maintaining databases is a snap, even though you are a rookie in SQL grammar.

3.1 now released!

3.1 version new features

  • Support MySQL Server 5.0.
  • Modify the kernel of converting mechanism, using ADO to replace Borland BDE.
  • Add ADO dataset, allow access database through ADO connection.
  • Allow selecting different database type in ODBC dataset, and getting the exact file data type.
  • Allow using Text dataset and FileDB dataset to read many text file or dbf file at one time.
  • Add WinExec function that allow execute a alone program.
  • Add function:FileName(),FilePath(),CopyFile(),MoveFile().
  • Not support Paradox. If you need to access Paradox, please use the old version.

3.0 version allow converting data to the following file:

  • Text file
  • HTML file
  • Excel spreadsheet
  • SYLK (Symbolic Link)
  • DIF (Data Interchange Format)
  • Lotus 1-2-3 file
  • QuattroPro file
  • XML file
  • Rich Text format
  • SPSS format
  • Adobe Acrobat Document(pdf)
  • LDAP/Lightweight Data Interchange Format

Key Benefits

Convert data between many database.

  • Support access MySQL through IP protocol directly.
  • Support access Oracle through IP protocol directly without Oracle client library installed.
  • Convert other database to MS SQL Server.
  • Convert other database to DB2.
  • Convert text data to MySQL, Oracle, MSSQL, DB2 or other database.
  • Convert data between many database through ODBC.
  • Directly read data from Paradox, dbase or FoxPro.

Flexible transfer function

  • Run job as custom execution flow.
  • Transfer a table; Merge more tables into one.
  • Split one table into more.
  • Automatically mapping between source and target tables.
  • Split source fields
  • Calculate between multi-fields
  • Multiple transfer modes: append, update, append-update, delete, copy.
  • Filter source data with flexible condition.
  • convert data of datetime type.
  • wipe off the repeated record of source dataset.
  • Split record.
  • Switch between row and col.
  • Generate temporary primary key.
  • Support debug dblink.
  • Preview result of convert process.
  • Re-process error data.

Run job as specified schedule automatically.

  • Run job automatically as day, week, month, year by seting datetime trigger.

Supported databases:

  • Oracle 10G, 9i, 8i, 8.0.x and 7.x
  • MySQL 5.0, 4.1, 4.0., 3.23 and earlier
  • Microsoft SQL Server 2000, 7.0 and 6.5
  • IBM DB2 8.1, 7.2, 6.1 and earlier
  • Informix 9.3, 7.3 and earlier
  • Microsoft Access 2000, 97, 95 and 2.0
  • dBase, FoxPro, Excel, Paradox,
  • Sybase Adaptive Server Anywhere
  • Sybase SQL Anywhere
  • Sybase Adaptive Server Enterprise
  • Interbase, Pervasive.SQL and any other ODBC-compliant database
  • Text file
  • HTML file
  • Excel spreadsheet
  • SYLK (Symbolic Link)
  • DIF (Data Interchange Format)
  • Lotus 1-2-3 file
  • QuattroPro file
  • XML file
  • Rich Text format
  • SPSS format
  • Adobe Acrobat Document(pdf)
  • LDAP/Lightweight Data Interchange Format

Support different databases and data type.

  • Read:Oracle, SYBASE, DB2, SQLServer, Informix, Interbase, Access, MySQL, dbf, Foxpro, Paradox, text file.
  • Write:Oracle, SYBASE, DB2, SQLServer, Informix, Interbase, Access, MySQL, dbf, Foxpro, Paradox, Text, HTML, Excel, SYLK, DIF, Lotus 1-2-3, QuattroPro, XML, RTF, SPSS, PDF, LDAP.
  • Support many data type: character string, integer, floating-point, bool, and datetime type.

DBPut runs on Microsoft Windows 98/ME/2000/XP/2003



Supported databases:

  • Oracle 10G, 9i, 8i, 8.0.x and 7.x
  • MySQL 5.0, 4.1, 4.0., 3.23 and earlier
  • Microsoft SQL Server 2000, 7.0 and 6.5
  • IBM DB2 8.1, 7.2, 6.1 and earlier
  • Informix 9.3, 7.3 and earlier
  • Microsoft Access 2000, 97, 95 and 2.0
  • dBase, FoxPro, Excel, Paradox,
  • Sybase Adaptive Server Anywhere
  • Sybase SQL Anywhere
  • Sybase Adaptive Server Enterprise
  • Interbase, Pervasive.SQL and any other ODBC-compliant database
  • Text file
  • HTML file
  • Excel spreadsheet
  • SYLK (Symbolic Link)
  • DIF (Data Interchange Format)
  • Lotus 1-2-3 file
  • QuattroPro file
  • XML file
  • Rich Text format
  • SPSS format
  • Adobe Acrobat Document(pdf)
  • LDAP/Lightweight Data Interchange Format

Support different databases and data type.

  • Read:Oracle, SYBASE, DB2, SQLServer, Informix, Interbase, Access, MySQL, dbf, Foxpro, Paradox, text file.
  • Write:Oracle, SYBASE, DB2, SQLServer, Informix, Interbase, Access, MySQL, dbf, Foxpro, Paradox, Text, HTML, Excel, SYLK, DIF, Lotus 1-2-3, QuattroPro, XML, RTF, SPSS, PDF, LDAP.
  • Support many data type: character string, integer, floating-point, bool, and datetime type.

DBPut runs on Microsoft Windows 98/ME/2000/XP/2003

No comments: