The last step in deploying a website, either on your own dedicated server or…through a hosting provider is to transfer your database structure and data if…necessary. Visual Web Developer includes a tool that allows you to create a…text file, a script that describes everything about your website including its…tables, columns, data types and so on. And even includes all of the data that…you have added to the database. When you use the Scripting tool you can choose…to export just the database structure or the structure and the data.…

To get to this tool go to the Database Explorer and go to the Data Connection…that you are using to connect your database. Right-click on the Database…Connection and select Publish to provider.…The Database Publishing Wizard has two modes that you can use. Click Next on…the introductory screen and select the database you want to work with, which in…my case is mybookstore.…In this screen you select either scripting to a file or publishing to a shared…hosting provider. If you are working say with a hosting provider and you are…

Resume Transcript Auto-Scroll

Author

Updated

2/13/2013

Released

4/28/2009

Thousands of businesses have used Microsoft ASP.NET to build professional, dynamic websites. In this course, web developer David Gassner demonstrates the tools needed to build and deploy a dynamic site using ASP.NET 3.5 or 4.5. Covering everything from installing and configuring Visual Web Developer 2008 or Visual Studio Express 2012 for Web and SQL Server Express to creating web form pages, this course is designed to give beginning and intermediate developers hands-on experience.

Skill Level Beginner

Duration

Views

Q: When trying to create a new database, after pasting the text into the SQL Management Suite and executing the query, the database is not created and the following message appears:

Database 'mybookstore' does not exist. Make sure that the name is entered correctly.

What is causing this error?

A: The database must be explicitly created before the script is run. Start by right-clicking on the Databases item in the left panel, then follow the prompts to create the database. Then retry the query.

Q: I am running into problems installing the latest version of ASP.NET. Has the installation procedure changed since this tutorial was recorded?

A: The installation process for the newest version of ASP.NET and its associated tools is a little different than in ASP.NET 3.5, which was used to record this course. You can download Microsoft Web Platform Installer 2.0 from:
<a href="http://www.microsoft.com/web/downloads/platform.aspx" target="blank">http://www.microsoft.com/web/downloads/platform.aspx</a>
Microsoft Web Platform Installer 2.0 includes everything you need:
ASP.NET 4?
Visual Web Developer 2010?
SQL Server Express
You must have one of the following operating systems:
Windows 7?
Windows Vista?
Windows Vista SP1?
Windows XP SP2+?
Windows Server 2003 SP1+?
Windows Server 2008?
Windows Server 2008 R2
You must have administrator privileges on your computer to run the Web Platform Installer.

Q: This course was updated on 2/13/2013. What changed?

A: Since this course was recorded, Microsoft has released both ASP.NET 4.5, the latest version of the server-side web application server, and Visual Studio Express 2012 for Web (the successor product to Visual Web Developer). Both have been adapted to work on Windows 8. There will be some visual changes and some functional changes, but most of the server-side code shown in the course is the same. This update provides a map for those working with the latest software so they can navigate their way through the course.

In particular, we added <em>What's new</em> movies for both ASP.NET 4 and 4.5, a movie explaining the significance of the update, a movie on installing SQL Server Express 2012, and one on exporting database scripts in SQL Server Management Studio 2012, as well as updates to visuals throughout the course.

Q: In the chapter on user authentication, an authentication error results when I try to use the Login component or register a new user. How do I fix this?

A: This is a known error that can occur when using the original release of Visual Studio 2012 Express for Web. Update your copy of Visual Studio for Web to at least maintenance release 1, and then try the exercise again.