• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

how to insert/update 7 different databases at the same time ?

i am using store procedure for my all the inserts and updates. Now based some condition i need to insert /update the details in the 7 different dabases. I have tried in the same store procedurte put its taking time and some time it is not inserted/updated properly in the all the 7 databses. Please provide me the solution for achive the task ...
0
Varshini
Asked:
Varshini
1 Solution
 
HainKurtSr. System AnalystCommented:
one sp in master db, 6 dblinks on others
call sp @ master, it will insert into master table and 6 tables on dblinks...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you explain the scenario a bit having 7 databases?
you might either check to use replication, or linked server in either direction to view/replicate data ...
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now