O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Transferring SQL server objects: DBMS Tasks

Transferring SQL database objects and data between databases is often needed in the real-world. For example, some scenarios could be the creation of the database environment along with multiple environments such as development, testing, and production; and for example, to create temporary tables to assist the ETL process.

This recipe demonstrates how we can simply transfer all database objects and data between the Adventure Works case sample and a new and empty database created for this recipe.

Getting ready

To get ready for this recipe, use the following steps:

  1. Open SQL Server Management Studio (SSMS) and connect to SQL Server.
  2. Create a temporary and empty database to which to transfer SQL objects from ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required