We have a main transaction database where all the live data is there.Now, to run a reporting application,we need a different database, but the data is as EXACTLY as the live database.So,probaly every noght aroung 1 0'clock,we want to sync
these two databases.
In this scenario,which is better, Snapshot replication or Transaction Replication? what are the pros and cons of using them?
As I am new to this things,ur answers would be very much helpful..
View Complete Post