|
|
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
|
|
|
|
That's great George, worked a treat.
Craig
|
|