I want to execute proc of database 'A' from database 'B'. My situation is this that i have a database 'A' and a database 'B'. I want that when a proc is executed on database 'A' it will also execute on database 'B'. This is because whole structure is same on both database but some procs are different in database 'B'. I want to match result effected by both procs in DB 'A' and DB 'B'. Is there is any solution for this problem. Please help me. Thanks in Advance.
A:
First of all, what DBMS are you using?
MySQL replicates stored procedures when using DB replication, so basic MySQL replication should just work.
Can Berk Güder
2009-02-10 13:32:47
I am using sql server 2005.Is it possible replication of stored procedures in sql server 2005?I have done replication and all procs are replicated but when i do changes in publisher ('A') DB it only reflects the changes of table in DB 'B', bt i want that the changes should hit DB 'B' using 'B' proc.
2009-02-11 05:00:09
I need both DB execute their own procs when updation is done in DB 'A'.
2009-02-11 06:06:41
Oh, I'm not sure, I never used MSSQL.
Can Berk Güder
2009-02-11 09:08:44
Its ok frnd. BTW thanks for your reply...
2009-02-11 12:41:13
+1
A:
If you are using SQL Server transactional replication, it is possible: Publishing Stored Procedure Execution in Transactional Replication and Replicate Stored Procedure Execution
Mitch Wheat
2009-02-10 13:33:52
I am using sql server 2005.I hv done transactional replication and all procs are replicated but when i do changes in publisher ('A') DB it only reflects the changes of table in DB 'B',bt i want that the changes should hit DB 'B' using 'B' proc.How to publish stored proc execution in sql server 2005.
2009-02-11 05:01:44