[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How does "publish database wizard" in MS SQL 2008 works?

Posted on 2009-02-12
Medium Priority
Last Modified: 2012-06-27
How does "publish database wizard" in MS SQL 2008 works?

Any examples? Any screendumps?

I'm not a DBA so please any answers must a little userfriendly :)
Question by:jensjakobsen
1 Comment
LVL 22

Accepted Solution

dportas earned 2000 total points
ID: 23627307
It generates scripts to create each object in your database and then executes them on a target server. Whether that's useful or not depends on what kind of change control and deployment methods you want to use. I don't think the publish wizard supports true incremental releases (altered columns, constraints, etc).


Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question