>>Do it in smaller chunks. Have scripts for each table which would insert perhaps one megabyte at a time. Use the ability of 2012 to insert multiple records at a time (something MySql had eight years ago) so you don't have to repeat the field names, as 2008 will accept that. Just tried this and it worked in 2008:
>
>Thanks
>
>It is only one table. And, that table is big. So, that will require considerable amount of time to prepare all that. I am looking at that presently.
Did you think about a temporary replication? You can setup 2012 as a push transactional publisher, create the snapshot and then you set up 2008 as a subscriber to the previous publication, once you have the table in 2008 you just delete the publisher and subscriber.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
