Take the 2-minute tour ×
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.

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.

1  
What is a "huge amount of data"? 1Gb? 1Tb? 1Pb? Millions, billions of rows? –  Mat May 29 '13 at 9:19
2  
1Gb these days is small, fits in RAM. You should explain exactly what your problems are rather than asking a very broad migration question. –  Mat May 29 '13 at 9:27
2  
Once you hit 100 TB - THEN you have vast amounts of data - 1 GB fits onto a single USB stick :-) –  marc_s May 29 '13 at 9:43
2  
200Gb is still in the rather small category. You'll be better off tuning your SQL Server than doing a migration to a completely different technology, unless you've got very specific reasons to do that switchover - 200Gb of data isn't a reason in itself. –  Mat May 29 '13 at 10:12
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

1 Answer 1

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.