Now my current database is working in SQL Server 2008 R2 and we are uploaded its only in 1 server. How can I migrate my existing database in to Hyper Table ? (My current database has huge amounts of data). I am not aware with Hyper table, any one help me?
closed as not a real question by Mark Storey-Smith, Paul White, Max Vernon, Marian, ypercube May 29 '13 at 12:02
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.
Hyper Table means that you have a hadoop backend. Hadoop can only have advantages if it can spread the workload over many, many, many of dedicated servers.
Hadoop process the data in large chunks (64 MB common). Hyper Table is also a column-store. Effectively you can only do scans over the whole data (eventually consistent).
You will lose all the transaction abilities of sql server 2008 R2.
And so on...
Please don't use hype technologies, before you really know what you do and how you have to use them.