SQL Azure Federations and SSDT

SQL Azure Federations and SSDT

Rate This
  • Comments 4

SQL Azure has recently introduced support for federated databases which enables an elastic scale-out solution in the cloud.  SQL Azure Federations introduces new syntax and management behaviors that are not currently supported by SSDT.  Support for federated databases will be added in a future release of SSDT.  Until that time, use of SSDT with SQL Azure federated databases, including root databases and federation member databases, is not supported by Microsoft.  You are strongly advised against using SSDT with federated databases as it may affect the structure of the database and could cause loss of data.  At this time you should use the SQL Azure Management Portal to create and maintain federated databases. 

You can learn more about SQL Azure Federations in this blog posting

Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
  • Any news on federations support in SSDT for SQL Azure? Is it at least in active development or just planning?

  • Hi Konstatin,

    Thanks for your interest in SSDT and Federations.  At this point, while this is an active topic we are not in a position to make any announcements yet.


    Bill Gibson

  • Is there some other recommended way of managing Azure Federations? I need something that can help me updating federation members and keeping track of changes. SQL Server database project in Visual Studio is also not helping as I see...

  • Hi,

    One year and a half after this blog post, is there some news about SSDT compatiblity with SQL Azure Federations ?

    Thanks !


Page 1 of 1 (4 items)