Migrating Indexes from SQL Server 2008 to SQL Azure?

Unlike SQL Server 2008, SQL Azure requires a clustered index to be created on every table. If you migrated a SQL Server 2008 schema didn't include a clustered index on a table to SQL Azure, you'll get the error you mentioned in your question. Add a clustered index to the offending table and the insert will work just fine.

Up vote 0 down vote favorite share g+ share fb share tw.

I am trying to migrate a database from SQL Server 2008 to SQL Azure. I believe I have successfully migrated all of my tables and stored procedures to SQL Azure. However, when I attempt to insert a record into one of my tables, I receive an error that says: System.Data.SqlClient.

SqlException (0x80131904): Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again. How do I migrate table indexes from SQL Server 2008 to SQL Azure.

Please assume I'm stupid. Sql-server-2008 sql-azure link|improve this question asked 1 hour agoJavaScript Developer453 70% accept rate.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.