Copy tickets to test environment

Hello,
I have two instances of OSTicket.

Currently, I copy the entire database once a night via cron job.

In order to make better use of my test system, I would like to copy all tickets, including assigned persons, via SQL.

Does anyone have a SQL script for this case?

Do a full dump and import it into production. Otherwise you are going to run into so many issues with ID mismatches, etc.

Cheers.