March 29, 2007 at 5:53 am
hello,
is it possible to have several replication types within the same database?
for example, for two tables i want "merge replication" with a central server, where twice a day data is merged?
and for three other tables, i want "transactional replication" with a central server, where data is immediately inserted?
thanks
March 30, 2007 at 10:11 am
The answer is yes, but you should really get some books on SQL replication or some help with what you are doing. I can think of a few things that could make this a very slippery slope for you.
Your question suggests you need some expertise to help you understand what you are doing and make sure this is really the correct approach.
March 30, 2007 at 4:57 pm
the problem is:
- i have a book "Beginning Sql Server 2005 Programming" from "Wrox", but there is nothing about replication in it.
- at our office there's a book "Programming SQL Server 2005" from o'reilly with very little information about replication. everything in that chapter goes via a c# programming (and i need to do it directly on the database).
- the online sql server 2005 tutorial contains a lot useful information, but it's so difficult to read an html manual (in almost each sentence there's a link to something else).
can you recommend me some useful books?
- a book "replication for dummies"
- and a book "replication advanced".
or some useful websites maybe?
- for dummies
- advanced information
now, don't think that i have no sql server experience. in contradiction, i'm already working 4 years with it, but on replication i'm new.
April 17, 2007 at 5:11 am
There is nothing wrong with using different types of replication within the same database. I use all forms in my environment and we even have a database that is a subscriber to merge and a publisher for transactional replication.
Regards
Graeme
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply