How do you transfer databases between two SQL Servers?

You can do it in a couple of different ways but this post shows you how you may do using the Export/Import Wizard. In particular, the post shows you, step-by-step, Copying the pubs database on a developer's edition of SQL Server 2012 to a developer's edition of SQL Server 2014.

Follow this step-by-step Swaytorial.
http:/sway.com/5HClf1YMOeTAERG9

Have you seen my recent Swaytorials on SQL Server 2012?

I think this new tool, SWAY from Microsoft is cool. Tutorials are so easy to follow as you can not only include images but media files as well. Text editing is somewhat limited but as it is, it is quite good.

If you have not watched may be you should review the following:



http://hodentekmsss.blogspot.com/2016/02/a-tutorial-on-creating-script-using-sql.html

http://hodentekmsss.blogspot.com/2016/03/easy-way-to-backup-sql-server-database.html

http://hodentekmsss.blogspot.com/2016/03/scripting-database-in-sql-server-2012.html

http://hodentekmsss.blogspot.com/2016/02/attaching-adventureworks2012-database.html

http://hodentekmsss.blogspot.com/2016/04/creating-scalar-valued-function-in-sql.html

These are all on my other blog which covers 100% SQL Server:

http://hodentekMSSS.blogspot.com

How do you bring in a database to a SQL Server?

There are several ways you can bring in a database to a SQL Server:
Attaching the database data and data-log files to the server:

• By restoring a backup of the database
• By executing a script file
• Using the Import/Export tool
• etc..

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 another hypothetical company.

How do you create a script in SQL Server Management Studio?

• This presentation is created using Microsoft's latest presentation program SWAY. This is my first shot at SWAY. The presentation may not be smooth. Would you kindly comment? Thanks

Scripting in SSMS 2012—Jayaram KrishnaswamyDocs.com

Test embed code: