Error #: 40517 -- Keyword or statement option 'pad_index' is not supported in this version of SQL Server.

May 10, 2011 at 9:49 AM

Hi I have run the migration wizard, but all of my tables are rejected as below:

09/05/2011 13:47:44 --> Error #: 40517 -- Keyword or statement option 'pad_index' is not supported in this version of SQL Server.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblTableName]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tblTableName](
 [id] [int] NOT NULL,
 [Name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_tblTableName] PRIMARY KEY CLUSTERED
(
 [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90)
)
END

Is there any way to get mw to remove the Pad_Index part as part of it's processing or am I doing something wrong?

Thanks in advance.

Craig

Coordinator
May 10, 2011 at 1:55 PM

 



Hi Craig,

 

Basically, you will get those if you don’t tell SQLAzureMW to analyze the database.  Please verify that you have “SQL Database” checked under “Analyze and Migrate”.

 

This should remove PAD_INDEX and other things not compatible to SQL Azure.

 

Let me know if this does not work for you.

 

Regards,

George

May 11, 2011 at 11:03 AM

That's great George, worked a treat.

Craig