https://community.qlik.com/t5/Talend-Studio/Database-and-tables-backup-and-restore/m-p/2340168#M108224 <P>Hello @Soumya M​&nbsp;,</P><P>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.&nbsp;</P><P>&nbsp;</P><P>Best regards</P><P>Aiming</P><P>&nbsp;</P> Wed, 12 Apr 2023 08:20:25 GMT Anonymous 2023-04-12T08:20:25Z https://community.qlik.com/t5/Talend-Studio/Database-and-tables-backup-and-restore/m-p/2340167#M108223 <P>Hello,</P><P>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?</P> Fri, 15 Nov 2024 21:54:35 GMT https://community.qlik.com/t5/Talend-Studio/Database-and-tables-backup-and-restore/m-p/2340167#M108223 Soumya_M 2024-11-15T21:54:35Z https://community.qlik.com/t5/Talend-Studio/Database-and-tables-backup-and-restore/m-p/2340168#M108224 <P>Hello @Soumya M​&nbsp;,</P><P>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.&nbsp;</P><P>&nbsp;</P><P>Best regards</P><P>Aiming</P><P>&nbsp;</P> Wed, 12 Apr 2023 08:20:25 GMT https://community.qlik.com/t5/Talend-Studio/Database-and-tables-backup-and-restore/m-p/2340168#M108224 Anonymous 2023-04-12T08:20:25Z