Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: Mapping one table to another in diffirent databases

    I want to map a table1 in one database to a table2 in another database. That way I can populate the table2 with the information that table1 has. How would you go about doing this. Very new at this and need help! Thanks alot .

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do you mean that if an INSERT, UPDATE or DELETE Occurs you wan the action reflected in that table?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Posts
    164
    Originally posted by Brett Kaiser
    Do you mean that if an INSERT, UPDATE or DELETE Occurs you wan the action reflected in that table?
    yeah, whenever something getts updated in one table in the database, the results will also reflect on the other table that lies it the other database. I am under the impression that yu have to map the databases together for that to happen. Is this something that is done with DTS? hopefully that makes a little more sence.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Sounds like a job for triggers.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Transactional replication can also be an answer.

Posting Permissions

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