0

This is my first use Azure Sql Databases. I have DB on my local and I connect to Azure Sql Database via Management Studio I want to export my local db to Azure but I get this error message

"Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again"

but table has a Id column as a primary key clustered index.

Local sql server : Sql Server 2012

So what should I do ?

Improve this question
2
  • Can you expand on the steps you took that led you to the error message? Commented Dec 26, 2013 at 8:17
  • I use the database->task->export options. But I see another option which is "deploy database sql azure". And I use it and fixed issue. Commented Dec 26, 2013 at 13:37

1 Answer 1

Reset to default
2

Sql Server Management Studio has "deploy database sql azure" command under tasks. I fixed this issiue by using this

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.