please help me regarding Federation in Azure SQL

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?

Hi Parveen,

 

https://azure.microsoft.com/en-in/resources/videos/introduction-to-sql-federation-part-1/ 

Here is one of the nice post. Please go through it:

https://www.sqlservercentral.com/blogs/sql-azure-federation