I am started using SQL Server 2012 MDS for maintaining our huge customer base. My question is whether MDS supports more than 10 million records? If so, how it is handled in excel? Excel has the number of rows limitation of 1 million.
Asked
Active
Viewed 234 times
0
-
This is answered in the [Maximum Capacity Specifications for SQL Server](https://msdn.microsoft.com/en-us/library/ms143432.aspx) – Gerald Schneider Apr 29 '16 at 07:49
1 Answers
0
Below is Quote from technet on same,posting relevant content here
Create Entity: Creating an entity from an Excel table is dependent on both the number of records and the number of columns, and appears to be linear in its progression. The number of attributes supported is based on SQL table limits, while the number of members will be constrained by Excel worksheet row limitations of 1M rows.
TheGameiswar
- 27,855
- 8
- 56
- 94