SQL Server: pushing development to production?

I'm currently using SQL Server 开发者_如何学CManagement Studio.

I have a development database, and access to a live database.

I just want to able to migrate my development tables to the live server.

I'm consulting stack flow first, since I don't want to blow anything up.

If you know what tables you want to migrate and they don't yet exist on the prod server, it's as simple as scripting the table definition, then running the script on the server. If it's more complex than that, I would recommend any number of tools which compare database schemas and automatically generate scripts you can run on the destination server to add/alter/remove what you need. A good freeware one for simple jobs is DBComparer. It's pretty basic. An excellent commercial one are the Sql Tools by Red Gate

We are using SQL Examiner Suite for this, but there are a lot of similar tools.

This is worth a look at - I've used it before and it works well and is very easy: Microsoft SQL Server Database Publishing Wizard http://www.microsoft.com/downloads/en/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en