Programming4us
         
 
 
SQL Server

Migrating Databases and Data to SQL Azure (part 2)

12/25/2010 9:38:06 AM
1.3. Setting Advanced Options

Clicking the Advanced button brings up the Advanced Scripting Options dialog shown in Figure 3. Follow these steps:

  1. In the Advanced Scripting Options dialog, set the following options:

    • Convert UDDTs to Base Types = True

    • Script Extended Properties = False

    • Script Logins = False

    • Script USE DATABASE = False

    • Types of data to script = Schema and data

    Figure 3. Advanced Scripting Options dialog

    You can also set the Script DROP and CREATE option to Script DROP and CREATE, as shown in Figure 3, but that option isn't required for SQL Azure.

  2. Click OK in the Advanced Scripting Options dialog, and then click Next in the Generate Scripts wizard.

1.4. Saving and Publishing

Complete the wizard with these steps:

  1. On the wizard's Summary page, review your selections, and then click Next. The T-SQL script is generated, and you're taken to the Save or Publish Scripts page (see Figure 4).

    Figure 4. Completed Scripted Process
  2. Click Finish. At this point your script is finished and is displayed in a query window in SSMS.

Other -----------------
- SQL Azure : Security - Access Control
- SQL Server 2008 : Full-Text Searches (part 3) - Stop Lists
- SQL Server 2008 : Full-Text Searches (part 2)
- SQL Server 2008 : Full-Text Searches (part 1) - Search Phrase
- SQL Azure : Securing Your Data (part 3) - Certificates
- SQL Azure : Securing Your Data (part 2) - Hashing
- SQL Azure : Securing Your Data (part 1) - Encryption
- SQL Azure : Security - Overview
- Setting Up a Full-Text Index (part 4) - Using the Full-Text Indexing Wizard to Build Full-Text Indexes and Catalogs
- Setting Up a Full-Text Index (part 3) - Diagnostics
- Setting Up a Full-Text Index (part 2) - Full-Text Indexing of BLOBs and XML
- Setting Up a Full-Text Index (part 1) - Using T-SQL Commands to Build Full-Text Indexes and Catalogs
- Implementing SQL Server 2008 Full-Text Catalogs
- How SQL Server FTS Works
- SQL Azure : Connecting to a SQL Azure Database (part 2) - Connecting from the Entity Framework
- SQL Azure : Connecting to a SQL Azure Database (part 1) - Connecting Using ADO.NET
- SQL Azure : Creating Databases, Logins, and Users (part 2)
- SQL Azure : Creating Databases, Logins, and Users (part 1)
- SQL Azure : Azure Server Administration (part 3) - Databases
- SQL Azure : Azure Server Administration (part 2) - Firewall Settings
 
 
Most View
- Exchange Server 2007: Monitor Your Exchange Environment (part 4) - Microsoft Operations Manager (MOM 2005)
- Troubleshooting and Optimizing SQL Server 2005 : Tuning the Database Structure
- SQL Server Integration Services : Running the SSIS Wizard
- Managing SQL Server Permissions (part 2) - Using SSMS to Manage Permissions at the Object Level
- Windows Server 2008 : Using Virtualization to Increase Productivity and Facilitate Consolidation - Introducing Virtualization & Server Consolidation
- Windows Server 2008: Understanding and Deploying BranchCache (part 2)
- Windows Phone 7 : User Interface - Using Panorama and Pivot Controls
- Windows Azure : Common Storage Tasks - Modeling Data
- Configuring Exchange Server 2003 to Coexist with X.400-Compliant Messaging Systems
- Microsoft Enterprise Library : Error Management Made Exceptionally Easy - Replacing an Exception & Logging an Exception
Top 10
- Implementing Edge Services for an Exchange Server 2007 Environment : Utilizing the Basic Sender and Recipient Connection Filters (part 3) - Configuring Recipient Filtering
- Implementing Edge Services for an Exchange Server 2007 Environment : Utilizing the Basic Sender and Recipient Connection Filters (part 2)
- Implementing Edge Services for an Exchange Server 2007 Environment : Utilizing the Basic Sender and Recipient Connection Filters (part 1)
- Implementing Edge Services for an Exchange Server 2007 Environment : Installing and Configuring the Edge Transport Server Components
- What's New in SharePoint 2013 (part 7) - BCS
- What's New in SharePoint 2013 (part 6) - SEARCH
- What's New in SharePoint 2013 (part 6) - WEB CONTENT MANAGEMENT
- What's New in SharePoint 2013 (part 5) - ENTERPRISE CONTENT MANAGEMENT
- What's New in SharePoint 2013 (part 4) - WORKFLOWS
- What's New in SharePoint 2013 (part 3) - REMOTE EVENTS