Post reply

Transactional Replication In SQLSERVER 2000

  • May 9, 2008 at 12:26 am

    #121983

    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 for replication.

    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 12:30 am

    #812822

    Hi

    Take a full backup of database1 and restore in database2. and use Transaction Replication.(real time) for both the database in sync. When ever the inserte, delete, update happens it will replicate immediately.

  • May 9, 2008 at 12:54 am

    #812834

    Thanks Jay,

    Sorry,but Restore will done only if the both the schema's are same mean table names ,field names and data types - length etc..

    but here not that case..here both are different schema's and different tables names. how can i restore..

    thanks

  • May 9, 2008 at 2:51 am

    #812882

    Hello you can do replicate for the same table name and same data types which exisits in both the databases or servers.....

    For example :

    If you have table A in a Database1 and Same structure of table in Database 2.... with same data types also..

    One thing you can do... copy the strucure of all table that u want in database2 and do transaction replication for those tables....

    if u want additional info... read this...

    http://blogs.techrepublic.com.com/howdoi/?p=123

Viewing 4 posts - 1 through 3 (of 3 total)

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