Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Talking Unanswered: MS SQL 2000 - How to reflect table updates

    Hello!

    I have 2 database (DB1 and DB2) in 1 server. I want to reflect new changes made in DB1.tbl_pm_project to DB2.tbl_pm_project. Any idea on how to do it.

    Thank you
    JJ-hon

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by jhonsz2001
    Hello!

    I have 2 database (DB1 and DB2) in 1 server. I want to reflect new changes made in DB1.tbl_pm_project to DB2.tbl_pm_project. Any idea on how to do it.

    Thank you
    JJ-hon

    What kind of changes? Structural changes or data changes? How often do the changes need to be reflected (real time, near real time or batch)?

    I'll assume data changes (insert, update, delete) and that the requirement is for real time.

    For two databases on the same server, your best bet is probably going to be a trigger. I do not like triggers that affect data across schema boundaries (ie, from one db to another), but this will probably be your quickest solution.

    See SQL BOL.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    Triggers or DTS or Replication.... according to your requirement.

    As you have only one table and if data is not huge then Trigger is fine else normally it is not preferred.

    It's all about how fast & consistent data changes you want to reflect.
    Last edited by rajeshpatel; 11-02-06 at 02:17.
    Rajesh Patel

    Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Or let a stored procedure update both databases in a transaction since they are on the same server.

    -- This is all just a Figment of my Imagination --

Posting Permissions

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