May 16, 2004 at 11:08 am
There are 10 servers in our Distributed Database system. Each server is responsible for processing regional accounts. But they have to communicate to each other to get some data. Each of these 10 servers will have identical code and table structure. Of course, data in the table will be different.
I am writing my stored procedure in one server. Then I need to copy it into all the servers. I cannot test my Stored procedure without my sp is copied to all servers because they interact.
Is there a tool or something available that will automatically copy my code to all servers?
Similarly, I need to delete and updates my Stored Procedures in all 10 servers.
What is the most efficient way to do this?
May 17, 2004 at 2:28 am
Batch job contains multiple osql command lines from the same input inputfile (sql statement or stored procedure) should do the job.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply