Find the changes that happened to all tables in last hour in Microsoft SQL Server

How can I find the changes that happened to all tables in last hour in Microsoft SQL Server? For example if a new record added I can find it with its ID or if a record deleted or update too.

I want to find them that I write a script to copy them to a new server. I have different servers that I want to write all changes to a server that it contains all of data.

If somebody has a better idea how to do it, it would be great if you would tell me, thanks.

Melissa Rogers

Melissa Rogers