July 15, 2002 at 7:43 pm
I am in the mids of designing a solution where I need to push data from 2 Live Production server into 1 Reporting Server.
What would be the best way yo get data accross to the reporting server? Would Replication be a better option?
Can Standby Server push transaction Logs from 2 servers into one single repository Server?
July 15, 2002 at 8:52 pm
I don't believe you can do the second option, but I have never tried. We use DTS in some situations to move the data to a common database and table. I am currently putting in place a test of replication of a single database from which we replicate out with a field to mark origination location and we will setup updating subscribers. This means however the data will exist in all three locations when done but this is for a security log so redundancy is what we are after.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 16, 2002 at 6:14 am
Replication is probably less work to maintain than DTS.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply