In my company i am facing following problem.please i want good solution.
We are following three environments of server.
1) development 2) Testing 3) Production
In my questions is i want move the data from production server to testing server daily basis.In my project we are using more then 600 tables. what are all the changes happened in production server ,it should be affect testing environment.I dont want current data.One day previous data enough.