quote:

---

What are the best pratices for setting up replication environment.

---

Be sure to read...

http://www.sqlservercentral.com/columnists/rsharma/enterprisevsstandardedition.asp

As far as i know Oracle supports only read committed and serializable for isolation levels ( read uncommitted also). SQL server supports all 4. Does this have anything to do...

thanks for mentioning the segmenting issue as well. I have worked in partitioned db environments in SQL 7.0 in a web based multimedia company. Application took care of redirection. Had...

hmm, sounds like a problem. 2Way trans replication is a requirement for us

sk

thanks. i will try the solution and post the results

-srini

quote:

---

srini_kris,

In function, our solution is virtually identical to log shipping, but the restores are handled in a single script, without copying backup...

quote:

---

We're hoping Yukon answers a lot of the high-scalability requests. Keep in mind that you have some method of load balancing using...

quote:

---

We tried replication under SQL 6.5, and, as I recall, replication would not push DDL (i.e., table and stored procedure) changes from...

Oracle 9i real app clusters will allow for this. One feature i wish Microsoft provides as we have requests for NLB too. The user should decide whether to cluster as...

Great article as this is something i have a need for. Since i am copying tables from server/db A to server/db B, is there a way to dynamically select all...

We have the same issue. If you script out replication and if your replication is simple then go for it, as log shipping needs a monitor server. also replication is...

quote:

---

I think using a table variable instead of a temp table will help you:

DECLARE @t1 TABLE( c1 int, c2 varchar(10) )

now @t1...

quote:

---

looks like someone comes from the novel world 😉 Srini, let us know what you end up going with. Replication can be...

thanks shawn. Looks like log shipping is a safer option

-sk