Hi, I´m testing Talend Data integration. I have a mysql database 2TB, but I need create another base to staging and dev. So, I don´t need total copy of database, just structure and some registres for ours developers. How could I reduce for this little database? what component could I use? The main problem in my point of view, should be the constraints between this tables. thanks.
Export / backup (t-SQL) scripts from database admin sqltool, I would go for that. Next You could use t(MS|My|)SQLRow to run the scripts if you want in Talend. I strongly suggest using your sql tool, like toad.
