Small copy to staging/dev

Small copy to staging/dev

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.



Ten Stars

Re: Small copy to staging/dev

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.

From a devops perspective, this is way faster.