Questions tagged [sql-azure-federations]

SQL Azure Federations single-shared database structures intended for use by multiple tenants through the use of database shards

SQL Azure Federations have been deprecated in favor of Azure SQL Database Elastic Scale:

The Azure SQL Database Federations feature is being retired along with the Web/Business editions in September 2015. At that point in time, applications that utilize the Federations feature will cease to execute. To ensure a successful migration, it is highly encouraged that migration efforts begin as soon as possible to allow for sufficient planning and execution.

References

19 questions
0
votes
1 answer

Is offline authentication possible with Azure Active Directory

I am currently using Auth0 for the offline authentication with downloading the token and validating the user against it. I am now looking to migrate to the Azure Active Directory - just want to double check if they have anything to support my…
0
votes
1 answer

Azure - How to get a list of federated databases?

In SQL Management studio, when connected to an Azure db, you can expand the 'Federations' folder and get a list of all federated databases. I'm trying to figure out the backing query that would find that info, but I'm having very limited…
Kyle
  • 17,317
  • 32
  • 140
  • 246
0
votes
1 answer

Federation key issue

I have to design a database for customer with email id as login but since we have lots of data we need to use federation but since we cant have string or varchar or nvarchar as federation key I am stuck at what should I do. User will use email id to…
0
votes
2 answers

The constraint 'IDENTITY' is not supported in a federated database

When am trying to create a table in federation am getting this error.How can I solve this. I have to use Identity. All things where set. but when try to apply federation this happens. Thanks in advance.
1
2