Description:

Chyfo is a powerful, flexible and high-performance database migration andmovement tool. Chyfo can be also used as a data export tool. This tool significantly facilitates the movement of database schemas anddata between different or same database systems. Chyfo uses the fastest,database native tools to import or load data. Chyfo can export data from anydatabase accessible through the ODBC interface. It exports data to text files (CSV, TAB delimited and fixed length aresupported formats), generates native DDL (Data Definition Language) andimport-load scri`pts for various databases. Chyfo uses the ODBC interface for exporting data only (Our tests show that the ODBC interface is fast enoughin comparison with native interfaces as regards the data export). Chyfo is especially designed for Oracle, IBM DB2 and Microsoft SQL Serverdatabases but can be also very helpful for other databases such as Sybase,Informix, MySQL, Access, FoxPro and others. It has a lot of features useful for DBAs: - This is a comprehensive command prompt tool. So you can create variousscri`pts to automate your work. The tool allows you creating scri`pts forregular data moving, loading into databases or datawarehouses. - You can provide a table name, a table template (like %.% to exportall tables of a database) or any SQL SELECT statement (from the commandprompt or a file) specifying the data to be exported. - Chyfo generates native CREATE TABLE and CREATE INDEX scri`pts for Oracle,IBM DB2 and MS SQL Server. - Chyfo generates native scri`pts for PRIMARY KEYS and REFERENTIAL CONSTRAINTSfor Oracle, IBM DB2 and MS SQL Server. - Chyfo generates loading scri`pts for specified database (control files for Oracle SQL Loader, IMPORT and LOAD scri`pts for IBM DB2). - You can provide a list of columns to be excluded from converting, startrow and number of rows to be exported. - Movement of LOBs (images, binary files) is completely supported.

Free demo download 53 KB

Buy full version $79.95