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 -----------------
- Migrating Databases and Data to SQL Azure (part 1) - Generate and Publish Scripts Wizard
- 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
 
 
Most View
- Windows Server 2003 : Configuring IAS for Use with VLANs
- Protecting SQL Server Data : CELL-LEVEL ENCRYPTION - Views and Stored Procedures (part 2) - Creating the Stored Procedures
- SOA with .NET and Windows Azure : Service Implementation with WCF (part 2)
- Windows Server 2008 : Managing the Terminal Services - Displaying Data Prioritization
- Windows Server 2008 : Configuring SMTP (part 2) - Creating a New SMTP Virtual Server
- Microsoft Dynamic GP 2010 : Installing Integration Manager (part 2) - SQL Server maintenance jobs
- Sharepoint 2007 : Start a Workflow
- Windows Small Business Server 2011 : A Networking Primer - Networking Hardware
- Windows 7 : Configuring Internet Explorer Security - Enhancing Your Browsing Privacy (part 3) - Enhancing Online Privacy by Managing Cookies
- SQL Azure Primer (part 3) - Connecting with SQL Server Management Studio
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