Import SQL Server 2008 db in Azure

I am using SQL server 2008, Want to import my db to Azure. I have (*.bak) file. Is their any work around to restore my db to Azure without changing my db structure.

I tried SQLAzureMW but it is giving me this error

'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.

I searched Filegroup keyword in scripts but it isn't there.

I also tried Azure SilverLight Managment Tool but it giving me same error.

While running this script i am getting the above error.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Mohsin].[Supplier](
    [SuppID] [int] NOT NULL,
    [Name] [varchar](50) NULL,
    [street] [varchar](30) NULL,
    [City] [varchar](20) NULL,
    [State] [varchar](20) NULL,
    [County] [varchar](30) NULL,
    [PostalCode] [varchar](25) NULL,
    [Phone] [varchar](17) NULL,
    [Fax] [varchar](17) NULL,
    [Active] [bit] NULL,
 CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED 
(
    [SuppID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

Answers


Make sure there isn't a reference for an Index or object indicating that it should go on the Primary filegroup. Search for ON [PRIMARY] or ON PRIMARY, or just the word PRIMARY.

The SQL Azure Migration Wizard is usually pretty good about pointing out exactly what it doesn't like.


Need Your Help

Html css image problems windows IE FF GChrome

html css internet-explorer

I have a website I have just built. Everything looks reasonable in Mac browsers, but in windows browsers such as IE there seems to be some rendering problems in terms of very thin sketchy white lin...

Add a Dynamic Total Row at the Bottom of Excel Spreadsheet Generated by VB.NET and SQL

visual-studio-2010 row excel-2010 add

I have an Excel Spreadsheet that I generated dynamically using SQL and VB.NET. The number of columns (2) will never change, however the number of records will change according to what data the user...