creating trigger across different databases

Question

Is there any way to create triggers on different databases? my requirement is like:-

 database: a1.db consist table: t1
 database:a2.db  consist table: t2

now i have to use trigger on t1 (whenever any delete and update operation) happens on t1 a value has to be inserted into t2.

waiting for your feedback...

Can you do this on SQLite? Thanks

Alex Poke
– Alex Poke

2014-04-02 09:05:53 +00:00
Commented Apr 2, 2014 at 9:05 — Alex Poke
– Alex Poke, Commented Apr 2, 2014 at 9:05

Josh Davis · Accepted Answer · 2009-12-02 13:10:36Z

3

I can only speak for MySQL, but you should be able to do something like:

CREATE TRIGGER ad_t1 AFTER DELETE ON `a1.db`.t1
FOR EACH ROW
INSERT INTO `a2.db`.t2 VALUES (...)

answered Dec 2, 2009 at 13:10

Josh Davis

28.8k5 gold badges54 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dcp · Accepted Answer · 2019-02-15 18:27:35Z

2

What are the other databases you are using besides mysql? If Oracle is one of them, then you can create dblinks from Oracle to the other databases, and your trigger (running on Oracle) could use those dblinks to update the tables in the other databases.

You can refer to this link for info on creating dblinks in Oracle: http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/statements_5005.htm

Also, see this link (How to create a DB link between two oracle instances) for another answer on stackoverflow.

edited Feb 15, 2019 at 18:27

answered Dec 2, 2009 at 13:08

dcp

55.7k24 gold badges149 silver badges169 bronze badges

1 Comment

dcp Over a year ago

@Mariusz.W - Removed and added link to another SO answer since the old link doesn't seem to be around anymore.

tzup · Accepted Answer · 2009-12-02 13:12:01Z

0

Looks like you need the MySQL equivalent of link servers (MSSQL) or dblink (Oracle). There is something called the FEDERATE storage engine:

Check here

answered Dec 2, 2009 at 13:12

tzup

3,6043 gold badges28 silver badges34 bronze badges

Collectives™ on Stack Overflow

creating trigger across different databases

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related