So I have the requirement of taking backup of Database (in the form of file, maybe .tar file) from one server and restoring the database to other server, also for few tables - these are two scenarios. How can I achieve this in Talend?
The easiest way to achieve this is to use the database's built in backup and restore functionality called via Talend. If this is command line based you can use a tSystem component, if it can be run from within the DB environment you can use tDBRow to call whatever statements you need. This can indeed be done with a tLoop and context variables.
