Results 1 to 3 of 3

Thread: linking an existing database table with a table in a new database

  1. #1
    Join Date
    Oct 2008
    Posts
    9

    linking an existing database table with a table in a new database

    Hi guys,
    I would like to know how to link a database that has a table which gets updated automatically and regularly to a new database in a new table such that this new table also gets updated.
    For example i have a database that records the login and logout details of an employee and but this database has to be not altered so i need to create a new database which should be linked to the existing database and such that the table gets populated with the data that is being collected by the existing database so that i can calculate the login hours of an employee.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can either implement a trigger or replicate the table to new database. Replication has less impact on performance of source table than a trigger but more complex to manage.

  3. #3
    Join Date
    Nov 2008
    Posts
    4
    I would suggest to simple make a view in your database that refers to the table-that-cannot-be changed.

Posting Permissions

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