Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

    
Really Sry its my mistake, our DB is more than 200 GB – Hari May 29 '13 at 10:01
    
1 more mistake ,Currently we Have 200 Gb it is only 3 months data, Actually we want to raise its 3 year means it will be 4 or 5TB and crores of rows also . So nw is it it better to stay with SQL or any other? – Hari May 29 '13 at 10:25
2  
"So my manager told me to change current DB in to Hyper table , It will make more performance. But in my life i heard first time the Name Hyper Table" - so ask your manager what it is. – AakashM May 29 '13 at 10:44
    
Sorry,he is just prfering Hyper Table, and he also have no more idea. So pleas give any valuble advice. Iam really stuck with this stuff. Hyper table is only good for more than 100 Tb or ? – Hari May 29 '13 at 10:54

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.

share|improve this answer
    
Edze thanks for u r valubale advice .So u are preferring Hadoop or stay with sql?. If sql then how shall i solve this pblm – Hari May 29 '13 at 11:20
1  
sql server...If you have to do some aggregation analyses over very large sequential datasets then you can store the results on a daily base to a other table. And this result can be aggregated again if need a result for the whole month etc. – edze May 29 '13 at 11:37

Not the answer you're looking for? Browse other questions tagged or ask your own question.