https://community.qlik.com/t5/Talend-Studio/Small-copy-to-staging-dev/m-p/2293544#M66505 <P>Hi,<BR />I´m testing Talend Data integration.<BR />I have a mysql database 2TB, but I need create another base to staging and dev.<BR />So, I don´t need total copy of database, just structure and some registres for ours developers.<BR />How could I reduce for this little database?<BR />what component could I use?<BR />The main problem in my point of view, should be the constraints between this tables.<BR />thanks.</P><DIV>&nbsp;</DIV><DIV><P>...</P></DIV> Sat, 16 Nov 2024 08:05:39 GMT Anonymous 2024-11-16T08:05:39Z https://community.qlik.com/t5/Talend-Studio/Small-copy-to-staging-dev/m-p/2293544#M66505 <P>Hi,<BR />I´m testing Talend Data integration.<BR />I have a mysql database 2TB, but I need create another base to staging and dev.<BR />So, I don´t need total copy of database, just structure and some registres for ours developers.<BR />How could I reduce for this little database?<BR />what component could I use?<BR />The main problem in my point of view, should be the constraints between this tables.<BR />thanks.</P><DIV>&nbsp;</DIV><DIV><P>...</P></DIV> Sat, 16 Nov 2024 08:05:39 GMT https://community.qlik.com/t5/Talend-Studio/Small-copy-to-staging-dev/m-p/2293544#M66505 Anonymous 2024-11-16T08:05:39Z https://community.qlik.com/t5/Talend-Studio/Small-copy-to-staging-dev/m-p/2293545#M66506 Export / backup (t-SQL) scripts from database admin sqltool, I would go for that.<BR />Next You could use t(MS|My|)SQLRow to run the scripts if you want in Talend.<BR />I strongly suggest using your sql tool, like toad.<BR /><BR />From a devops perspective, this is way faster.<BR /><BR /><BR /> Thu, 14 Jun 2018 21:55:45 GMT https://community.qlik.com/t5/Talend-Studio/Small-copy-to-staging-dev/m-p/2293545#M66506 Jesperrekuh 2018-06-14T21:55:45Z