Roy Ernest (8/9/2011)

---

You can alter the stored proc used for replicating the inserts to suit your needs. The SP will be in your subscriber DB (TestDb). The stored proc will...

Actually, I'm not there. This is becoming more and more of a pain in the butt.

Okay, on the Live database there's a column named Processed which is either set to...

Sorted it.

http://blogs.msdn.com/b/repltalk/archive/2010/02/26/logreader-fails-with-cannot-execute-as-the-database-principal-because-the-principal-dbo-does-not-exist.aspx

Used that guide and it all works perfectly now.

Thanks everyone for your replies.

I've attempted to set up replication but I'm getting errors on the Log Reader Agent.

I've looked a bit online but I can't find anything concrete for...

Roy Ernest (8/8/2011)

---

If it need to be pretty fresh, then your option is transactional replication. But there is a drawback when you want to use it.

You cannot allow your...

Lowell (8/8/2011)

---

Welcome aboard Jimmy;

A few questions:

Instance1 and Instance2 are seperate servers, right, and not databases?

so the commands are really referencing ServerInstance1.LiveDatabase.dbo.Table1 and you want to migrate some data to OtherServerInstance.TestDatabase.dbo.Table1?

Or...