I need to get a table with data from accross the wan at our company. Actually the data is in Chicago and I am in California. The table I need to get over to my local sqlserver database has 12million rows. It took 4 hours to get 3million, so 12 hours to get the data is way too long. Does anyone know of a better solution?