Windows Azure SQL Database is a cloud-based relational database from Microsoft. It is a different version that traditional SQL Server.

learn more… | top users | synonyms

14
votes
1answer
6k views

How can I alter an existing Primary Key on SQL Azure?

I want to modify an existing primary key on a SQL Azure table. It currently has one column, and I want to add another. Now, on SQL Server 2008 this was a piece of cake, just did it in SSMS, poof. ...
5
votes
5answers
5k views

How do I copy my SQL Azure database to a local SQL Server instance?

I have an OLTP database hosted on a SQL Azure instance. I want to pull a copy of the database down from the cloud so I can run some heavy extracts and OLAP-style queries against it without impacting ...
4
votes
1answer
667 views

Linked server to SQL Azure very slow

I can use the Management studio to connect directly to my Azure SQL database and execute this query: select * from DB.dbo.DSeries where instrument='name1' and it works really fast. But if I create ...
0
votes
0answers
15 views

Azure Copy Database Failed

We have four different environments: DEVINT, TEST, STAGE, and PROD, each on their own Azure SQL Database server. I can copy a database between any two of these, using the command CREATE DATABASE mine ...