tags:

views:

36

answers:

3
+2  Q: 

SQL Server: pushing development to production?

I'm currently using SQL Server Management 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.

A: 

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

SQLDev  2010-10-22 13:15:32
There must be a way to do it in Managerment Studio though
Nick  2010-10-22 13:18:25
VS2010 do it, but 3rd party tools are much more usable and powerfull
SQLDev  2010-10-22 13:26:51
+1  A: 

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

BBlake  2010-10-22 13:23:53
I'll trying the scripting method then.
Nick  2010-10-22 13:27:57
Red Gate rocks. I absolutely love their tools and at this point consider it the ONLY real way of migrating schemas between dev/stage/production.
Chris Lively  2010-10-22 14:12:54
Also, I've never had any luck with the microsoft tools. Whether it be the stuff built in to management studio like Copy Database, import/export, and publish to web service or the ones included with Visual Studio Team like the Schema or Data compare. For whatever reason they just can't get this right. SQL Compare by redgate on the other hand has always worked flawlessly.
Chris Lively  2010-10-22 14:15:52
yea, I would love to have Red Gate at my disposal, but I've never worked anywhere that would spring for the cost. That's why I use the DBComparer freeware right now for most of that stuff I need to do.
BBlake  2010-10-22 20:09:40
A: 

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

jules  2010-10-22 13:27:40

related questions

Sql to query a dbs scheme
Transform Columns into Rows
SQL Client for Mac OS X that works with MS SQL Server
How do you get leading wildcard full-text searches to work in SQL Server?
SQL Server 2000: Is there a way to tell when a record was last modified?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
I need to know how much disk space a table is using in SQL Server
What's the best way to determine if a temporary table exists in SQL Server?
Appropriate pagefile size for SQL Server
Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?
ASP.NET MVC "CRUD" Database Sample
How do I unit test persistence?
Best Book for a new Database Developer
Can I logically reorder columns in a table?
Best way to copy a database in SQL Server 2005/8?
Is Windows Server 2008 "Server Core" appropriate for a SQL Server instance?
Why doesn't SQL Full Text Indexing return results for words containing #?
Client collation and SQL Server 2005
Editing database records by multiple users
Deploying SQL Server Databases from Test to Live
SQL Server 2005 implementation of MySQL REPLACE INTO?
Upgrading SQL Server 6.5
How do I version my MS SQL database in SVN?
How to export data from SQL Server 2005 to MySQL
Check for changes to a SQL table?