Trailer for SQL 2012 Developer tutorial: "Design and Deployment" with Expert Instructor -- Don Kiely.
Get full course details @ http://bit.ly/11Hfhc8
In this course you will learn about a number of useful features in Data Tools, including its use for both online and offline database development. In online mode you can use the new SQL Server Object Explorer that provides many of the same features as Object Explorer in SQL Server's Management Studio. You'll see how to create databases and other objects as well as change existing objects. You'll also see how to compare database schemas, a very useful tool used internally by the data tools that you can also use directly. In offline data base development you can create a database project using a Visual Studio template. You can ether import an existing database schema or create objects from scratch. You will see how both these modes work and see how you can publish changes to an existing database.