Replication design

Hi,
I'm new to MSSQL replication, and was hoping for some advice as to
recommended practices for my scenario.
I will have a 4 SQL server scenario at four locations connected through a
TCP/IP wan (i.e. each site is connected to the internet).
One of the sites is the headquarters site. Some tables are only updated
at the headquarter, and these changes should replicate to the other sites.
For example the table that contains the list of all products is only updated
at the main site.
Each site (including the headquarter) inserts many transactions within the
day. I wish for all the transactions to replicate to all sites. For
example, if I insert a transaction at site A, I want this transaction to
replicate to site B, site C, and headquarters as well. The same goes for
all sites. Ideally this should happen within an hour from when the
transaction was entered.
The databases will be about 10-15GB each I think.
Any comments or suggestions appreciated,
Edgard
Edgard,
for those tables which are only updated at HO, I'd recommend transactional
replication.
For all other tables I'd recommend merge.
One hour's latency should not be a problem, provided you have the necessary
bandwidth and the amount of changes is not too great.
Regards,
Paul Ibison

REPLICATION BETWEEN MSSQL SERVER and postgresql/MySQL/ORACLE?

Hi Friends,
I want to know if there are a manner of replication(two-way) between MSSQL SERVER and (postgresql or mysql or ORACLE).

ThanksReplication between MS SQL Server and Oracle is supported, but not for the other two. You can search SQL Server 2005 Books Online for "replication and oracle", there should be many topics to read. Oracle is supported as a publisher and a subscriber.|||

Replication is available for Oracle for one way only, meaning either Oracle publisher with SQL subscriber or SQL publisher with Oracle subscriber.

I presume when you say 2-way, you mean bi-directional. This scenario is not suppoted.

Gary

Replication

Mssql 2005 - Mssql2000
I try to create a "Transactional publication with updatable subscriptions:"
But I can see that all tables cet an added colunm "msrepl_tran_version"
Is it possible to replicate 2-way that wil not add this column
(msrepl_tran_version)?
What will happen if I set up "Transactional publication" in both Database.
ie. both is a Publisher and Subscriber at a same time?
The data that will be updated and inserted will newer confilct in our
environment. (The Software we use manage this.)
Roger Nygrd
Ask IT
Roger,
these links should help you set up bi-directional transactional replication:
http://support.microsoft.com/default...b;en-us;820675
http://msdn.microsoft.com/library/de...lsamp_3ve6.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||It works well. You don't need this msrepl_tran_version column. Please see
this script for an example of it.
http://www.indexserverfaq.com/bidireproscript.sql or
http://www.indexserverfaq.com/Mike1.sql
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
"Roger Nygrd" <roger@.askit.no> wrote in message
news:11surfla2d9svab@.corp.supernews.com...
> Mssql 2005 - Mssql2000
> I try to create a "Transactional publication with updatable
> subscriptions:"
> But I can see that all tables cet an added colunm "msrepl_tran_version"
> Is it possible to replicate 2-way that wil not add this column
> (msrepl_tran_version)?
> What will happen if I set up "Transactional publication" in both Database.
> ie. both is a Publisher and Subscriber at a same time?
> The data that will be updated and inserted will newer confilct in our
> environment. (The Software we use manage this.)
> Roger Nygrd
> Ask IT
>
>

Replication

Hi guys,
Is it possible to replicate in MSSQL SERVER standard edition and be
supported? Or do I need to buy enterprise edition.

Regards

Jaideepjai (dba_sybase2003@.yahoo.com) writes:
> Hi guys,
> Is it possible to replicate in MSSQL SERVER standard edition and be
> supported? Or do I need to buy enterprise edition.

You can do replicaiton in Standard Edition.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Yeah I kind of knew that replication is possible in the standard
edition but will MIcrosoft support it.

Regards

Jaideep|||jai (dba_sybase2003@.yahoo.com) writes:
> Yeah I kind of knew that replication is possible in the standard
> edition but will MIcrosoft support it.

Yes.

Please check Books Online, the book SQL Server Architecture ->
Implementation Details -> Editions of SQL Server 2000 ->
Features Supported by the Editions of SQL Server 2000.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland,
I am new to sql server replication but I have worked with sybase
replication. At present, the machine housing the sql server has 2 g of
memory with 1.4 g for sql server. How much more (memory), would I need
if I make the same machine work as publisher as well as the
distributor?

Regards

Jaideep|||jai (dba_sybase2003@.yahoo.com) writes:
> Erland,
> I am new to sql server replication but I have worked with sybase
> replication. At present, the machine housing the sql server has 2 g of
> memory with 1.4 g for sql server. How much more (memory), would I need
> if I make the same machine work as publisher as well as the
> distributor?

You will have to ask the friendly people in
microsoft.public.sqlserver.replication about that. My own experience
of replication is very thin. My gut feeling is that it would depend a
lot of the data volume you intend to replicate.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"jai" <dba_sybase2003@.yahoo.com> wrote in message
news:1124737698.551148.233410@.z14g2000cwz.googlegr oups.com...
> Erland,
> I am new to sql server replication but I have worked with sybase
> replication. At present, the machine housing the sql server has 2 g of
> memory with 1.4 g for sql server. How much more (memory), would I need
> if I make the same machine work as publisher as well as the
> distributor?

Howmuch data do you expect to replicate at any time?

Basically all that happens is the log reader puts rows into a distribution
DB which then gets used to distribute them to the subscribers.

You probably have enough RAM since you can't get much more in Standard
version anyway.

> Regards
> Jaideep