I work on a database structure that has a lot of data in it. This database structure is used by approximately 40 different servers. I want to change some of the table structures, by adding some columns to tables, etc, but I do not have time to change 40 database structures.
How can I change all databases structure without losing any data with a script?
Can I backup a database structure without data and restore it to the other servers without them losing their data?
The servers are Microsoft SQL Server 2005.