From: dontspammenow on
Hello.

Using SQL Server 2008. I'm developing on my local PC with a copy of
the DB that is contained on a web host. Is there a good way when I do
an alter table on the local DB to export that change to the web host
DB and have "semi-automatically" apply the change to its copy of the
table?

From: Erland Sommarskog on
dontspammenow(a)yahoo.com (dontspammenow(a)yahoo.com) writes:
> Using SQL Server 2008. I'm developing on my local PC with a copy of
> the DB that is contained on a web host. Is there a good way when I do
> an alter table on the local DB to export that change to the web host
> DB and have "semi-automatically" apply the change to its copy of the
> table?

There are a number of ways to do this. A solution which is popular with
many is to use Red Gate's SQL Compare. Personally, I prefer to keep my
code under version control, so it is not really my solution, but the
tool as such work very well.

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx