Support Center

Working with Visual Studio to design Tables

Last Updated: May 01, 2014 09:34PM AEST
This article has moved to a new home. For up-to-date documentation please continue reading at

Visual Studio 2012 (and Visual Studio 2010 with SSDT installed) comes with a rich set of tools that let you work online with your database, so that you never have to leave the IDE.
When you create a new ReadyRoll project, a new database will be automatically created for you.
To get started, open the SQL Server Object Explorer (SSOX) window and expand the(localdb)\Projects SQL Server instance to reveal your new database. Navigate to the schema and begin creating new objects using the built-in designers.

When you want to apply your changes, click Update and then Generate Script: ReadyRoll will add the generated script to your project for review prior to deployment. When ready to deploy, pressStart [F5] or use the Deploy Project command.


ReadyRoll will then perform a “gated deployment” on your database: after the script is parsed, your migration script is deployed to a copy of the project database (namedMyDatabase_MyUsername_SHADOW). This step ensures that not only does your script contain valid object references, but also that your target database does not drift from your project database. For example, it prevents an ALTER operation occurring before a CREATE operation.
Here’s the output from the Deploy command:
You can then check your scripts into source control, deploy to upstream environments (DEV/TEST/PROD) or receive scripts from other team members.


Further reading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found