I have a list of "Customers" in a SQL database table with some very basic data:Id, Name, DoB, Mobile, Email, CusotmerType.
There are currently about 80,000 customers
I wanted to use an External Content Type/External Content List to link a list to the table...and while this works, I've hit the 2,000 throttle limit.
Is there a way I can regularly, on a schedule, "import" or "create" this list so that i can get around the limit? 80,000 is not really a LOT of data!
I would prefer to use only SPD or the browser Admin pages to do this - I need to keep any custom code to an absolute minimum as I am the only support member of staff!
The data is only refreshed nightly, so a schedule would be ideal.