Replication
-
Anybody know about a good document to learn and set up replication? Cheers Al
-
Anybody know about a good document to learn and set up replication? Cheers Al
No, as far as I can figure, there are no good ones. I think the reason is that there are so many "ifs and buts", i.e. technique x works, but only if you structure your inserts this way, but if you have a BLOB column then you have to do it another way unless the planets are out of alignment, and then you have to apply the "jupiter" hotfix. Its just too complex to write about in any meaningful way. Unless you are willing to put many many hours into the learning effort, my best advice is to hire a consultant. As a bonus, you'll have someone to blame when things go wrong.
-
Anybody know about a good document to learn and set up replication? Cheers Al
Hi, As far as SQL Server replication goes, the best bet is http://msdn.microsoft.com/librarydefaul.asp?url=/library/en-us/replsql/replover\_694n.asp You could also learn to implement replication on the internet through the front end e.g using SQL Merge Replication Object for Merge Replication. The URL for the same is at MSDN , a few links below the link given above