October 20, 2015 at 5:07 pm
Dear all:
Is there anyone familiar with database sharding? I don't have much knowledge of that. But currently we need to move some of the historic data from one sharding to another sharding since one entity was later assigned to a new sharding? The current solution is to use the original source data and ETL to the new sharding but it's way too complicated since you have to deal and massage the raw data again. Would it be easier to move the Data from the old shardings?
Any input will be appreciated!
Thank you so much!
October 21, 2015 at 2:52 am
SQL Server doesn't have sharding.
It doesn't scale out easily, it's very, very, very hard to scale out a SQL Server. Any moving of historical data has to be done manually.
What, exactly are you trying to do? The more detail you give, the more likely someone will be able to offer a solution.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply