Federation retirement warning message in Azure SQL Database

Symptoms

When you run the CREATE or USE FEDERATION command on Azure SQL Database, you may receive the following warning:

Federations functionality is deprecated. You will not be able to use the Federations feature in the near future. Your existing Federation members will be automatically switched out to stand-alone databases. This will be a non-reversible change. For more information, go to http://go.microsoft.com/fwlink/?LinkId=619688.

Or you may receive the following error message:

Federations functionality is deprecated and the USE FEDERATION command is no longer available. In the near future, your existing Federations will be automatically switched out to stand-alone databases. This will be a non-reversible change. To avoid any current or future business discontinuity, contact Microsoft Support using following instructions: http://go.microsoft.com/fwlink/?LinkId=620181. You will not be able to access data in Federations, or issue the USE FEDERATION command, in the near future. The USE FEDERATION command is no longer available.

Cause

The Federations feature retires with the sunset of Web and Business editions. You will no longer be able to use Federation commands. Additionally, your existing Federation members will be switched out to stand-alone databases. This will be an irreversible change. Your application will stop working permanently until you make the changes needed to disable the Federations functionality.

Resolution

For new scalable database applications:

Use Elastic Database features for Azure SQL Database. These features simplify building and managing an application that uses sharding. A .NET client library allows applications to define how data is mapped to shards and routes OLTP requests to appropriate databases. To reconfigure how data is distributed among shards (split and merge data from one shard to another), Elastic Database includes an Azure cloud service template that you can host in your own Azure subscription. If you are not familiar with Elastic Database tools, see the Elastic Database tools getting started page and also the documentation map.

For existing Federation applications:

Migration tools are available to help you move from Federations to Elastic Database applications, without performing any data movement. Please refer to this documentation and video for conceptual overview of Federation Migration. To manually detach federation members if you choose to migrate to stand-alone databases or use custom sharding approaches, we have added the ALTER FEDERATION statement. Use this to detach individual federation members and work with them as stand-alone databases. This is an alternative to using the Federation Migration Utility.

What if my application is not yet ready to work without Federations?

Follow these steps to create an Azure Support ticket that describes your situation:
  1. Go to Azure Portal.
  2. Click Help + support.
  3. Click New support request to create a new support ticket.

  4. For Request Type, select Quotas, and for Resource, select SQL databases.
  5. For Problem Category, select Quota or Core increase requests SQL database, and then click OK.
  6. In the Issue Details section, explain that you are a Federations customer who has an application that cannot currently work without USE FEDERATIONS functionality. Make sure that your contact information reflects the email and contact number where you want to be contacted.
  7. Click OK, and then click Create. A member of the Azure SQL Database product team will contact you. The person who contacts you will use this information and discuss your options.

What will happen if I take no action by October 2015?

If you decide to take no action by October 2015, your Federation members will be auto-migrated to stand-alone databases. This will be an irreversible change, and you will be unable to use your existing application without making the required modifications to not use Federations.
Proprietà

ID articolo: 3087180 - Ultima revisione: 13 ago 2015 - Revisione: 1

Feedback