Scripting a database in SQL Server 2012

You may need to use your database on one server on another server. Perhaps you just want to have a copy to work with to try something. In this case you need to somehow get it on to the other server. The following video created using Microsoft Sway shows the procedure. Just use the navigation keys at the bottom right.

Enjoy this new format of presentation.

How do you script a database?—Jayaram KrishnaswamyDocs.com

Attaching AdventureWorks2012 database to a SQL Server Instance

Sample database files are great if you are interested in learning the basics of SQL Servers and SQL Querying.

After installing the SQL Server the first thing you may have to do is bring in some data. Microsoft has provided lots of samples and AdventureWorks is one such database of a hypothetical company and it is bigger than the Northwind database of a hypothetical company.

Here is a Swaytorial that helps you to bring in data to your server. Enjoy!

Attaching a database to SQL Server Instance—Jayaram KrishnaswamyDocs.com