Microsoft® SQL Server® 2012 Bible

807 Chapter 31: Managing Data in Windows Azure SQL Database 31 as imposing a heavy load or fi lling up the transaction logs (don ...

808 Part V: Enterprise Data Management You may wonder why the SQL Server Import and Export Wizard isn’t listed here. The answer ...

809 Chapter 31: Managing Data in Windows Azure SQL Database 31 You must follow four steps to complete this wizard, as shown on t ...

810 Part V: Enterprise Data Management In the list of objects in Figure 31-3, expand the Tables and Stored Procedures nodes, an ...

811 Chapter 31: Managing Data in Windows Azure SQL Database 31 ■ (^) Check for Object Existence = True ■ Script Extended Propert ...

812 Part V: Enterprise Data Management This example really doesn’t need the extended properties, so those can be excluded. Same ...

813 Chapter 31: Managing Data in Windows Azure SQL Database 31 Click Finish. At this point your script is fi nished and display ...

814 Part V: Enterprise Data Management and uses the with option to specify procedure options: in this case, recompile (to indi- ...

815 Chapter 31: Managing Data in Windows Azure SQL Database 31 to remove are those listed in step 3 (PAD_INDEX, ALLOW_ROW_LOCKS, ...

816 Part V: Enterprise Data Management CONSTRAINT [PK_Contact_ContactID] PRIMARY KEY CLUSTERED ( [ContactID] ASC )WITH (STATISTI ...

817 Chapter 31: Managing Data in Windows Azure SQL Database 31 replied that SSIS relies on SQL Server Management Objects (SMO) f ...

818 Part V: Enterprise Data Management You now see an SSIS package designer surface. This surface has several tabs along the top ...

819 Chapter 31: Managing Data in Windows Azure SQL Database 31 FIGURE 31-10 Verifying Empty Contact and Employee Tables. Buildin ...

820 Part V: Enterprise Data Management FIGURE 31-12 Defi ning a New Connection in the Connection Manager for SQL Database. In t ...

821 Chapter 31: Managing Data in Windows Azure SQL Database 31 Back in the Execute SQL Task Editor, click the Ellipsis button i ...

822 Part V: Enterprise Data Management Clear Data task: Click anywhere on this green arrow, and drag it to the fi rst data fl ow ...

823 Chapter 31: Managing Data in Windows Azure SQL Database 31 FIGURE 31-14 Source to Destination Mapping. FIGURE 31-15 Complete ...

824 Part V: Enterprise Data Management Put down the root beer, though, because you aren’t quite done. You still need to confi gu ...

825 Chapter 31: Managing Data in Windows Azure SQL Database 31 FIGURE 31-17 Successfully executed SSIS Package. Errors you recei ...

826 Part V: Enterprise Data Management FIGURE 31-18 Viewing the Migrated Data. This section isn’t intended to be an SSIS primer. ...