Microsoft Visual Studio 2015 Unleashed, Third Edition

Changing the Database

With a fully populated database project, you can now make any desired changes by opening any of the generated .sql files and editing the file. This works the same way that object editing works using the Server Explorer or the SQL Server Object Explorer: you can edit the raw SQL commands using the SQL editor or, if you opened a table’s .sql file, for instance, you can edit the table definition by using the designer or the SQL editor.

You can control a number of database and server options via the database project. You can access all these via the Project Properties dialog. These would rarely need to be changed by a developer (they are more likely to be within the database administrator’s scope of work), but let’s briefly ...