May 16, 2004 at 11:00 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 9:17 am
Have a look at Embarcadero Change Manager.
Excellent to use and very easy to set up.
Go to this page and look under the heading 'Migration Facility'; you can peform multi-target migration, which looks like what you are after.
http://www.embarcadero.com/products/changemanager/cmdatasheet.html#compare
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply