-
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.
-
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.
-
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
-
Forum Rules
|
|