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
- SQL Azure : Design Patterns (part 1)
- iPad SDK : New Graphics Functionality - We Are All Tool Users (part 2) - The Pencil Tool
- Exchange server 2010 : Designing and Implementing Messaging Records Management (part 2)
- Windows 8 : Applications - The Run Dialog Box, Closing a Program
- Windows Server 2003 : Managing Daily Operations - Delegating Control & Using Task Scheduler
- Windows Server 2008 : Configuring Network Authentication (part 2)
- Publisher Certificates
- Exchange Server 2010 : Upgrading from and Coexisting with Exchange Server 2003 (part 9) - Moving Offline Address Books
- PerformancePoint Services 2010 (part 3) - Upgrading PerformancePoint Server 2007 & Migrating Content to Another SharePoint 2010 Location
- Windows 7: Recovering from a Problem
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