What is jDTS?
Is a library in JAR format to transfer data between tables of the same or diferent databases.
Features
Still not much...
- You can transfer records between diferent databases
- You can transfer values between tables with diferent field names.
- You can execute commands (ALTER TABLE, DROP TABLE, INSERT, Stored Procedures, etc.).
- It lets you to choose wether you want a LOG of the transfers, and the path of this file.
- It lets you to save in a variable the value of a field in all the records of a resultset.
- It lets you delete those records that have in a field of your choice one of the values saved in a variable.