0

Am very new to azure federation.In my project there is an SQL azure database and now we want to use azure federation for scaling that database.

Is it possible to Federate the existing table ?.

How can I achieve this on my existing table casedetails. Am planning to federate the table based on customer_Id.From where should i begin.

in my scenario casedetails table against customerid which is the FK from Customer table.

Will it affect the queries used in the existing web application to fetch and insert values to the database ?.

How can i migrate data into the federated databse.. I am also facing a problem from identity not supported in federation. few of my tables contains identity specification and lots of data. Please reply if u have any insight relating to the problem.

Thanks in advance.

Anish Karunakaran
  • 987
  • 3
  • 17
  • 39
  • Have you looked at this http://msdn.microsoft.com/en-us/magazine/hh848258.aspx – Chandermani Jul 01 '13 at 06:11
  • Ya.. But it describes on federation at table creation itself. In my scenario all are set except federation. – Anish Karunakaran Jul 01 '13 at 06:34
  • I believe you cannot federate existing tables. You need to migrate the date into a federated database to support federation. – Chandermani Jul 01 '13 at 06:48
  • Sry I didn't get you fully.. Could you please elaborate a little. – Anish Karunakaran Jul 01 '13 at 07:12
  • @Chandermani How can i migrate data into the federated databse.. I am also facing a problem from identity not supported in federation. few of my tables contains identity specification and lots of data. Please reply if u have any insight relating to the problem. – Anish Karunakaran Jul 11 '13 at 05:17

0 Answers0