Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Mumbai
    Posts
    1

    Unanswered: Updating of the tables in two different databases

    I am using SQL server7.0. I am having two databases ,say database A and database B.Database A is the main database which is used in two /three projects.While database B is created by me for my work.From the database A, I am using the 4/5 tables, which i have copied in to the database B.
    So, i want to update these tables in the database B as soon as any change (insert,update or delete ) occures on the tables in the database A.
    That's why I am interested in doing these work.I have tried, but it doesn't work.So, I have placed these into these forum.


    Do anybody is having script fordoing these job.Plz,mail it to me Urgently...

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    Well, you could place a trigger on the DB A's tables for insert, update, delete and then have it modify DB B's tables.

    Remember that when in another DB to reference another database's tables it is:
    db.owner.table

    so you'd want to reference b..table.

    Or, you could set up replication from DB A to DB B for those particular tables. I haven't used replication extensively in SQL 7 so I do not know if this is possible or easy to do.
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •