CODEWITHSUNDEEP
sqlazureexportazure-sql-database
user2482077
user2482077

Reputation:

exporting local db to azure sql databases

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 ?

Upvotes: 0

Views: 530

Answers (1)

user2482077
user2482077

Reputation:

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

Upvotes: 2

Related Questions