> I have 2 SQL Servers: production server and developing server.
> I have made changes in the structure of some tables in developing server.
> I know exactly which changes I made but I don't want to apply them
> manually in order to reduce mistakes. I would like to apply those
> changes in the production server. Is it possible to apply those changes
> using a script ? Is there a way to create this script automatically ?
> A no cost solution is better.
For a no-cost solution, see http://www.abaris.se/abaperls/. But I should
warn you that this is only a no-cost solution in that the software is
free. There is probably a bit of learning curve.
What it is all about, is the tools that we use in our shop. Our baseline
is not a development servers. We have an uncountable number of development
servers, so that is out the question. Rather our baseline is the version-
control system, which in our case is Visual SourceSafe.
The toolset includes a tool that generates an update script in Perl, of
all changed files between two labels. For a table, you get a template
script to move the data from the old incarnation to the new incarnation.
Books Online for SQL Server SP3 at