Hi
I am new to replication and I have a few simple questions.
My goal is to setup a database where I can store a history of all records that were deleted/updated/inserted with out the overhead of triggers on the production server.
In other words I want to create a database on another box that would pull data from two other servers, and then (through update,delete triggers track changes to the main tables). Right now we are using Merge replication to track history, but since it's not based on each transaction only the latest update gets recorded. (If you want me to describe it in more detail feel free to ask)
1. Can I use Trasactional Replication in simple recovery mode? (I'm worrying that not all transactions are written to log)
2. Can I use Trasactional Replication to retrieve data from multiple subscribers? Can I resolve conflicts in similar fashion to merge replication if changes are made at two subscribers?
3. Is it possible to achieve transaction level replication with Merge Replication?
(I'll come with more questions...)
If you can help me with any above or some interesting links regarding replications (please do not point me to BOL or MSDN as I am reading it right now) I would greatly appreciate it.
I should be getting a copy of SQL Server to play with soon, for now only forums and google.
I am new to replication and I have a few simple questions.
My goal is to setup a database where I can store a history of all records that were deleted/updated/inserted with out the overhead of triggers on the production server.
In other words I want to create a database on another box that would pull data from two other servers, and then (through update,delete triggers track changes to the main tables). Right now we are using Merge replication to track history, but since it's not based on each transaction only the latest update gets recorded. (If you want me to describe it in more detail feel free to ask)
1. Can I use Trasactional Replication in simple recovery mode? (I'm worrying that not all transactions are written to log)
2. Can I use Trasactional Replication to retrieve data from multiple subscribers? Can I resolve conflicts in similar fashion to merge replication if changes are made at two subscribers?
3. Is it possible to achieve transaction level replication with Merge Replication?
(I'll come with more questions...)
If you can help me with any above or some interesting links regarding replications (please do not point me to BOL or MSDN as I am reading it right now) I would greatly appreciate it.
I should be getting a copy of SQL Server to play with soon, for now only forums and google.