how to configure one-way merge replication?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jessy (Jessy_at_discussions.microsoft.com)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 11:49:02 -0800

I am using SQL Server 2000. I want to copy a table data periodically from one
database to another database. i set up a merge replication - DB1 is the
publisher and DB2 is the subscriber. The subscriber is pulling from DB1.
Right now whenever I insert or update data on either DB it will update both
ends. Instead i want to just pull from DB1 into DB2. I dont want data to be
updated to DB1. I understand this is possible by changing the exchangetype.
I will like to change the exchangetyp from the default to '2'. How do i use
the command prompt replmerg.exe to set this value. What are the required
parameters when setting the replmerg ? I will appreciate it if someone can
give me a step by instruction to set this up correctly. If there is another
alternative let me know.
Also i have another question. If DB1 tableA has col1,col2,col3 and DB2
tableB has col1,col2,col3,col4 can these two tables replicate?
I am wondering if the two tables need to have the same number of fields and
types.

Relevant Pages

  • Re: Table Synchronization across databases on the same server
    ... Triggers will add to the overhead of the application which uses DB1. ... should be able to use log shipping or transactional replication for what you ... you will be unable to update tables on db2. ...
    (microsoft.public.sqlserver.replication)
  • Re: Table Synchronization across databases on the same server
    ... > inhouse application which maintains a transactional database, DB2 also ... Since the DB1 is frequently updated the ... Anyway, I'm not very good at replication myself, I would encourage you to ...
    (comp.databases.ms-sqlserver)
  • Re: screwed non-us7ascii characters while selecting from a database link
    ... db1: ... db2 on SUSE SLES9. ... CREATE DATABASE LINK db1_link CONNECT TO user IDENTIFIED BY password ... from db1 and imp them into db2 the characters are converted correcly. ...
    (comp.databases.oracle.server)
  • SQL DB to MySQL
    ... We have SQL Server 2000 databases residing on one server, ... DB1 contains the main data, ... DB2 contains data about the most recent changes to DB1, The key, table ID, ... Our plan is to schedule a DTS package to update the MySQL database. ...
    (microsoft.public.sqlserver.dts)
  • Query Analyzer Default Database
    ... You have to set 'DB2' as ... all the ODBC connections ... Database To" option in the ODBC settings, to DB1. ...
    (microsoft.public.sqlserver.server)