Take the 2-minute tour ×

If somebody could point me into the direction how to learn about this or even if its possible.

I'm developing a new website locally with SQL Server 2005. I dislike having to detach it, ftp it to the production server then to reattach it.

Is there a way where I can make my development testing server put the new version of the SQL Server database to the production server? Sometimes I might add a few columns or change a datatype. Over time it its a hassle. My current method is to open a live database and to just add the new column or whatever. But its time consuming and there must be an easier way.

Thanks for any help. Wayne

share|improve this question
This is quite a general question, because you're really asking "how do I deploy schema changes?" The answer depends a lot on your toolset and environment. Some people use VSDB (now SSDT), others use third-party tools, other build their own deployment scripts. –  Pondlife Nov 15 '12 at 22:28
add comment

2 Answers

Redgate's SQL Compare and SQL Data Compare.

share|improve this answer
Thank you I had never heard of redgate's products I might give them a try. –  Wayne Lambright Nov 21 '12 at 11:59
add comment

Just maintain DDL SQL scripts(alter table add column) and execute them at production.

share|improve this answer
Thank you, this is helping me in the right direction and that's all I needed. I'll post back what I find out. –  Wayne Lambright Nov 21 '12 at 12:00
add comment

Your Answer


