New to replication, advice needed

hi,
our app works in a multi tier model to provide inet connectivity
now a customer wants to be able to keep working even if the inet is down or
the main server is down
so the obvious solution is to use replication
so:
1) what is the best place to start understanding what is involved
2) all relations are now by the use of integer PK's, some of them are auto
generated, does this has to change?
3) can i have only selected tables replicated?
4) can i have only a subset of rows of a table replicated?
tia!
Marc
1. BOL, www.replicationanswers.com, go for merge replication
2. N
3. Y
4. Y
Hope this will help
-Ravi Lobo
"Marc Antheunis" wrote:

> hi,
> our app works in a multi tier model to provide inet connectivity
> now a customer wants to be able to keep working even if the inet is down or
> the main server is down
> so the obvious solution is to use replication
> so:
> 1) what is the best place to start understanding what is involved
> 2) all relations are now by the use of integer PK's, some of them are auto
> generated, does this has to change?
> 3) can i have only selected tables replicated?
> 4) can i have only a subset of rows of a table replicated?
> tia!
> Marc
>
>
|||1) Well there's my book. Query Replication Tutorials on the web
2) No, not for one way transactional replication. With merge replication DRI
is maintained but another tracking column is added - a guid column.
3) Yes, for transactional replication all tables must have a pk, with merge
they don't require a pk.
4) Yes, as long as there is a criteria to filter it by you can replicate a
subset of rows - this is called horizontal partitioning or horizontal
filtering.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marc Antheunis" <ask_me@.ask.me> wrote in message
news:uCKSLCKJFHA.2956@.TK2MSFTNGP12.phx.gbl...
> hi,
> our app works in a multi tier model to provide inet connectivity
> now a customer wants to be able to keep working even if the inet is down
or
> the main server is down
> so the obvious solution is to use replication
> so:
> 1) what is the best place to start understanding what is involved
> 2) all relations are now by the use of integer PK's, some of them are auto
> generated, does this has to change?
> 3) can i have only selected tables replicated?
> 4) can i have only a subset of rows of a table replicated?
> tia!
> Marc
>
|||Hi Hilary!
i just phoned the biggest IT related book store in belgium but they don't
sell your book
awaiting an answer from them if it is availabel in belgium
i'll try to collect some ideas and post some to the point questions
thx
marc
"Hilary Cotter" <hilary.cotter@.gmail.com> schreef in bericht
news:eXyQEfLJFHA.3928@.TK2MSFTNGP09.phx.gbl...
> 1) Well there's my book. Query Replication Tutorials on the web
> 2) No, not for one way transactional replication. With merge replication
> DRI
> is maintained but another tracking column is added - a guid column.
> 3) Yes, for transactional replication all tables must have a pk, with
> merge
> they don't require a pk.
> 4) Yes, as long as there is a criteria to filter it by you can replicate a
> subset of rows - this is called horizontal partitioning or horizontal
> filtering.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Marc Antheunis" <ask_me@.ask.me> wrote in message
> news:uCKSLCKJFHA.2956@.TK2MSFTNGP12.phx.gbl...
> or
>
|||You can get it from Amazon.com or you can order it by following this link:
http://www.nwsu.com/0974973602.html
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marc Antheunis" <ask_me@.ask.me> wrote in message
news:uCCa01LJFHA.1860@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Hi Hilary!
> i just phoned the biggest IT related book store in belgium but they don't
> sell your book
> awaiting an answer from them if it is availabel in belgium
> i'll try to collect some ideas and post some to the point questions
> thx
> marc
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> schreef in bericht
> news:eXyQEfLJFHA.3928@.TK2MSFTNGP09.phx.gbl...
a[vbcol=seagreen]
down
>