You can use an existing database server instead of Local DB, but depending on your version of Visual Studio and your type of database, all of the data tools in Visual Studio might not be supported.
If the tools are not available for your database, you may need to perform some of the database-specific steps within the management suite for your database.
In some cases, you may wish to start over from a known set of data every time the project is deployed.
In other cases, you may not want to alter the existing data in any way.
Based on your requirements, you can decide whether you need a post-deployment script or what you need to include in the script.
In the last part of the series, you will deploy the site and database to Azure.To see that the new database has been created, open SQL Server Object Explorer and look for the name of the project in the correct local database server (in this case (localdb)\Projects V12).To see that the tables are populated with data, right-click a table, and select View Data. Your database is now set up and populated with data.In Visual Studio, click the Start button (or F5) to build and deploy your database project.Check the Output tab to verify that the build and deployment succeeded.This part of the series focuses on creating a database and populating it with data.This series was written with contributions from Tom Dykstra and Rick Anderson. NET Scaffolding, you can create a web application that provides an interface to an existing database.This tutorial series shows you how to automatically generate code that enables users to display, edit, create, and delete data that resides in a database table.If you have a problem with the database tools in your version of Visual Studio, make sure you have installed the latest version of the database tools.For information about updating or installing the database tools, see Microsoft SQL Server Data Tools. You will deploy this database to Azure later in this tutorial, so you'll need to set Azure SQL Database as the target platform for the project.