ITKeyword,专注技术干货聚合推荐

注册 | 登录

解决asp.net - Visual Studio 2012 - Database Publishing Wizard Discontinued?

itPublisher 分享于

2020腾讯云双十一活动,全年最低!!!(领取3500元代金券),
地址https://cloud.tencent.com/act/cps/redirect?redirect=1073

【阿里云】双十一活动,全年抄底价,限时3天!(老用户也有),
入口地址https://www.aliyun.com/1111/home

推荐:在 Visual Studio 2012 中创建 ASP.Net Web Service

在 Visual Studio 2012 中创建 ASP.Net Web Service,步骤非常简单。如下: 第一步:创建一个“ASP.Net Empty Web Application”项目 创建一个“ASP.Net Empty W

I'm using VS 2012 and SQL Server 2008 and have just noticed that the "Publish to Provider" option is missing in Server Explorer. According to this, Database Publishing Wizard has been discontinued?

http://forums.asp.net/post/5122271.aspx

How can I publish my database to my server now? Is generating scripts the only option instead of doing this from within the VS IDE and if so, can someone provide the steps to generate the DB with stored procedures included?

UPDATE:

asp.net visual-studio sql-server-2008 visual-studio-2012
|
  this question
edited Oct 8 '12 at 13:52 asked Oct 8 '12 at 13:06 IrishChieftain 12.6k 5 35 70

 | 

2 Answers
2

You can deploy/update database schema from Visual Studio:

  1. VS2012: View -> SQL Server Object Explorer panel
  2. right click on your database -> Schema Compare...
  3. choose remote database as a target

|
  this answer
answered Nov 5 '12 at 13:01 Lu55 8,198 3 32 28

 |  解决方法

Solution was to use SSMS in SQL Server 2008. Right-click database node in Object Explorer. Select Tasks -> Generate Scripts, and complete the wizard with the desired options. Not very satisfactory for a quick and simple deployment from within VS...

推荐:在 Visual Studio 2012 中创建 ASP.Net Web Service 转

http://blog.csdn.net/xinyaping/article/details/7993989 转 在 Visual Studio 2012 中创建 ASP.Net Web Service,步骤非常简单。如下: 第一步:创建一个“ASP

Some tutorials:

http://www.sqlchick.com/entries/2011/3/12/scripting-out-data-in-sql-server-2008-r2.html

http://www.mssqltips.com/sqlservertip/2500/sql-server-2008-r2-generate-scripts-wizard-with-database-schema-and-data/


|
  this answer
edited Oct 9 '12 at 3:03 answered Oct 8 '12 at 14:02 IrishChieftain 12.6k 5 35 70

 | 

推荐:【转载】在 Visual Studio 2012 中创建 ASP.Net Web Service

在 Visual Studio 2012 中创建 ASP.Net Web Service,步骤非常简单。如下: 第一步:创建一个“ASP.Net Empty Web Application”项目 创建一个“ASP.Net Empty W


相关阅读排行


相关内容推荐

最新文章

×

×

请激活账号

为了能正常使用评论、编辑功能及以后陆续为用户提供的其他产品,请激活账号。

您的注册邮箱: 修改

重新发送激活邮件 进入我的邮箱

如果您没有收到激活邮件,请注意检查垃圾箱。