How would I replicate data between two db that are the same. One is for my office and one is for my webpage. My webpage db is at another location from my office db. How would I have SQL 2000 merge the data between the two db's?
Check "Implementing Replication" in SQL Books Online (BOL). Check the section on "Implementing Replication Over the Internet." You will also benfit from reading about the "Types of Replication," especially "Merge Replication." Terry
;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.