Post reply

Transactional Replication in SQLSERVER 2000

  • May 8, 2008 at 6:43 am

    #125186

    Hi every body,

    I need some valuable suggestions from you.

    Here I have entirely two different databases. I need to communicate both the databases in real-time manner. My questions are…

    1.First i need to dump all the existing data from database1 to database2, which is having no relevant fields in it and it’s located at other server – How?

    2.Second thing if any insertions, updations and deletions occur in table1 in database1 immediately effect in table2 in database2 Bi-Directional. – How?

    Here both servers having SQLServer2000-sp2.

    Here database1 having 350 tables and database2 having 100 tables, but I need only 20 to 30 tables.

    There are some solutions I found in web.

    1.DTS package

    2.Transactional Replication

    3.Writing triggers

    Please suggest me which is suitable to above criteria.

    Thanks in Advance

  • May 9, 2008 at 7:39 am

    #813044

    First I will admit to not fully understanding your question; however if you mean a table in both DBs can be updated at the same time (bi-directional) then you would need Merge replication.

    2. Second thing if any insertions, updations and deletions occur in table1 in database1 immediately effect in table2 in database2 Bi-Directional. – How?

    Toni

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply