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
- Windows Server 2008 : Installing the Web Server Role (part 1)
- Windows 7 : Displaying the Router’s Setup Pages
- SQL Server 2008: SQL Server Web Services - Building Web Services (part 2)
- Windows 7: Troubleshooting Tools (part 1) - Running the Windows 7 Troubleshooters
- Developing for Windows Phone and Xbox Live : What Is in a New Project?
- Microsoft Dynamics GP 2010 : Installing the Dynamics GP 2010 application
- Exchange Server 2010 : Availability Planning for Client Access Servers (part 4) - Creating a Client Access Server Array
- Scripting Windows 7 with WSH : Programming the WshShell Object (part 2)
- SharePoint 2010 : SQL Server Reporting Services 2008 (part 1)
- Windows 7 : Configuring Hardware and Applications - Managing Printers
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