In my Organization, we do have a requirement to get last hour modified data from production database (some of the large tables) to other support teams.
So, we are suggesting to go with replication. However, Our DBA is saying that replication is failure model (they are saying it will slow down the performance).
Our DBAs are suggesting a approach to introduce new column to those tables and track the last modified time.. They will export those records using bcp utility and provide that data to other support teams. .. Is this approach good?
Is there any specific issues exist with SQL Server replication?
Please suggest the general industry practice on this scenario..
Thanks in advance!