Having trouble with CREATE TABLE. Some of my tables are not actually getting into SQL Azure.
I have a VS 2010 RDBMS project that I'm attempting to migrate via 3.5.SQL Azure MW 3.5.3. After deploying to SQL I Analyze-and-Migrate from TSQL file. The resulting TSQL contains a few CREATE TABLE statements with this pattern:
CREATE TABLE [dbo].[MyName] (
[Col1] NVARCHAR (50) NOT NULL,
[Col2] NVARCHAR (50) NOT NULL
) ON [PRIMARY];
Other tables get generated statements like:
CREATE TABLE [dbo].[MyOtherName] (
[ColA] NVARCHAR (50) NOT NULL,
[ColB] NVARCHAR (50) NOT NULL
CONSTRAINT [IX_MyOtherName] UNIQUEUE NONCLUSTERED ([ColA] ASC) WITH (IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
The tables like MyName do not get into Azure, but tables like MyOtherName do.
The SQL Azure MW generated RTF contains this error for each of these MyTable cases:
Error #: 40514 -- 'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.
Is there a configuration setting or command line or other option that I can use to cuase the 1st CREATE TABLE pattern to omit the "ON PRIMARY" clause between the last ')' and ';' characters?