CODEWITHSUNDEEP
sqlazureazure-sql-database
Matt
Matt

Reputation: 26971

How do I create foreign keys in Azure DB?

How do I create foreign keys in Azure DB ? I can't find it in the silver-light Azure DB manager and when I connect with SSMS, when I don't get the same GUI options to add foreign keys. Do I really have to use manually written scripts to accomplish this? (Yes I'm lazy)

EDIT: I guess I could create my schema in SQL SERVER - EXPORT AND IMPORT.... I will try that and report. (Creating it on SQL server and exporting and running on Azure worked)

Upvotes: 2

Views: 1115

Answers (2)

Richard Mitchell
Richard Mitchell

Reputation: 421

You can also use SQL Server Management Studio 2008 R2 to connect to Azure and edit the database directly. Or you could use a free service like http://www.queryanywhere.com/.

Full disclosure: I work for Red Gate

Upvotes: 2

Igorek
Igorek

Reputation: 15850

There is currently no GUI available to do this.

However, if you have Red Gate SQL Compare, you can use it to synchronize changes in schema from a local SQL server to SQL Azure with a few clicks.

HTH

Upvotes: 2

Related Questions