How to copy data from one table to another on SQL Server 2008 R2?

Question

Database design

I do accounting of arrivals and departures to the workplace at my enterprise in the web interface. People pass through the turnstiles, beep with passes and into the database, data is written into the tablet. They say Ivan Ivanovich came to work at 08:13.
I wrote an interface for a timekeeper in php, worked on a MySQL base, as a prototype. The server is running SQL Server 2008 R2. How can I make it so that the data from the plate, where the passages of people through the turnstiles are written, are automatically written to my plate? tables in the same database.

Answer 1

It is better not to produce entities and use the original tablet. If this is not possible, then the decision will depend on how quickly you need to copy the data. If you need a copy once a day/hour, then it's better to make a job. If you need a copy of the operational - then hang on the original table trigger for insertion, not forgetting that the trigger increases the load on the database.