Hi,
I am not sure about how to solve the following task:
I have a number of distributed PCs each with MS SQL server and a database. I need to maintain the databases (schemer changes, table changes, F. key changes etc.). I have a main sever where I maintain the database manually.
What I would like to do is: after the main database has been updated on the main server, have the distributed servers automatically receive the new update scrip’s and the databases updated.
This is probably a large and complicated task. If I can be pointed in the right direction how this to be achieved; what services SQL server has to offer, or do I need other special software, I would be very grateful.
Wayne
c-code-it 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.