Transfer Anywhere has been replaced by GoAnywhere , which is the "next generation" solution for automating and securing data movement. Click here to learn more.
Transfer Anywhere can connect to a variety of database servers, including DB2 on the iSeries, Oracle, SQL Server, Informix, Sybase and MySQL.
Database records can be replicated between database servers using Transfer Anywhere. For instance, a transfer could be defined to copy records from an iSeries physical file into a SQL Server table. This transfer could be scheduled and automated.
Records (rows) are retrieved from database servers using standard SQL statements. A SQL Wizard is provided in Transfer Anywhere to allow you to quickly generate SQL statements for selecting fields, filtering records and sorting records.
After selecting the records from the source database server, the user can then indicate the target database server and table to copy (pump) the records into. The database columns (fields) can be mapped using an intuitive wizard.
Records can be appended to the end of a table or can replace the existing records in the table.
1409 Silver Street 