621
Chapter 23: Transferring Databases
23
With a focus on generating scripts with Management Studio, open the Management Studio
script generator; select the database you wish to script out in the console tree, right-click,
and select Tasks ➪ Generate Scripts.Skip the Welcome to the Generate SQL Server Scripts screen by clicking Next. At the Choose
Objects screen, as shown in Figure 23-3, you have the option of scripting out the entire
database and all of the database objects together. Alternatively you can select to script out
only specifi c database objects such as tables, views, stored procedures, etc.FIGURE 23-3
Management Studio can generate scripts for any objects within the database.c23.indd 621c23.indd 621 7/31/2012 9:25:21 AM7/31/2012 9:25:21 AM
http://www.it-ebooks.info