August 12, 2004 at 1:40 pm
What is the maximum amount of data that can be copied to data file using bcp utility? We need to download table contain 70GB of information in order to load it to the other database that cannot be connected to the input database. Do we have to split it by parts?
August 12, 2004 at 3:05 pm
The largest table I've ever BCP'd was about 35Gb and it worked fine. I'm not aware of any size limitiations within BCP itself.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 13, 2004 at 2:11 am
The limit is only your HW and OS, not the BCP
Bye
Gabor
August 13, 2004 at 1:07 pm
BCP should handle it. But I would suggest:
1) drop indexes on the table receiving the data
2) make sure your transaction log is large enough. OR, if you don't want the BCP to log, turn bulk-logging off.
3) Make sure your DB is large enough BEFORE bcp'ing the data. OR make sure you're grabbing some large extents when the DB wants to increase in size (so you don't end up with a horribly fragmented DB).
3) bcp the data in
4) build you indexes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply