Database Publishing Using Web Deploy

Question

I've had success in using Web Deploy to publish my web page, however the database (schema and data) are not being published at all.

.NET 4.5
MVC 5
EF Code First 6
Visual Studio 2013 for Web

I get no errors, the remote database connection is fine.

What am I missing?

What errors you are getting when you tried to browse to the website? — Rosdi Kasim
– Rosdi Kasim, Commented Jul 26, 2015 at 0:58
Hi Rosdi, it's not so much about browsing the website, it's the fact that when I look at the database, there aren't any tables. — user1470994
– user1470994, Commented Jul 26, 2015 at 1:09
The tables will be created when you first browse the website. — Rosdi Kasim
– Rosdi Kasim, Commented Jul 26, 2015 at 1:35
Which back to my first question, what errors you are getting when you browse the website? — Rosdi Kasim
– Rosdi Kasim, Commented Jul 26, 2015 at 2:09

iman mir · Accepted Answer · 2015-07-26 06:00:32Z

1

In iis right-click the site that you are configuring, point to Deploy, and then click Configure Web Deploy Publishing in "Enter SQL SERVER connection String enter your database connection string

answered Jul 26, 2015 at 6:00

iman mir

2411 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user1470994 Over a year ago

I'm deploying through Visual Studio.

iman mir Over a year ago

@user1470994 Before publish from visual studio in IIS server config SQL server connection string same as that picture

user1470994 Over a year ago

Thanks, however, that still did not work and is what I already have in my original question. I solved my problem by pointing the 'defaultconnection' to my remote server in my Web.Config file.

Collectives™ on Stack Overflow

Database Publishing Using Web Deploy

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related