MS SQL Server Merge Replication

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Mahmoud KHEBAISA

    MS SQL Server Merge Replication

    Hi, I have two databases on MS. SQL Server 200 the first one is the
    main DB and the second one is a replica of it, both of them in
    different territories .I connect them using merge replication just
    when I need to merge the data.

    The problem is when I make import data or export data from any
    location (MS access ,MS SQL server ) to the second one (subscriber DB)
    or the main DB(publisher and distributor ) ,the imported data does
    not replicated to the other DB ???

    Normal transaction replicated smoothly.

    I hope you can help me.

    Thanks in advance.

    Mahmoud Khebaisa.
  • Simon Hayes

    #2
    Re: MS SQL Server Merge Replication

    mahmod79@hotmai l.com (Mahmoud KHEBAISA) wrote in message news:<ce543867. 0408190341.2cd2 244@posting.goo gle.com>...[color=blue]
    > Hi, I have two databases on MS. SQL Server 200 the first one is the
    > main DB and the second one is a replica of it, both of them in
    > different territories .I connect them using merge replication just
    > when I need to merge the data.
    >
    > The problem is when I make import data or export data from any
    > location (MS access ,MS SQL server ) to the second one (subscriber DB)
    > or the main DB(publisher and distributor ) ,the imported data does
    > not replicated to the other DB ???
    >
    > Normal transaction replicated smoothly.
    >
    > I hope you can help me.
    >
    > Thanks in advance.
    >
    > Mahmoud Khebaisa.[/color]

    You might want to post this in microsoft.publi c.sqlserver.rep lication
    to get a better answer. You should probably also mention exactly how
    you are importing the data which are not replicated, eg. DTS, bcp.exe,
    a custom tool etc.

    Simon

    Comment

    Working...