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:
Open SQL Server Management Studio (SSMS) and connect to SQL Server.
Create a temporary and empty database to which to transfer SQL objects from AdventureWorksLT2012 database.
Under Database Folder, press New Database....
Provide a name for the new database (
AdventureWorksLT2012_DEV) and keep the remaining properties as default.Open SQL Server Business Intelligence Development Studio (BIDS) and...
