Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amy7756
Starting Member
2 Posts |
 Posted - 2008-05-13 : 14:59:49
|
| Hi All -I'm trying to use the "import data" option in Management Studio (sql server 2005) to get data from one server to another. It works for smaller tables, but on one of my larger tables it fills tempdb (I am not loading to tempdb!). Any idea why it would be using tempdb, and how I can get it to NOT use tempdb? At this point I think I'm going to just use bcp out/ bcp in to get the data over, but I'm sure that's not the fastest way...Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-13 : 15:03:04
|
| Did you do mappings of tables correctly b/w source & destination server? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 15:16:46
|
| It shouldn't fill tempdb.How big(size) is your table? |
|
|
|
amy7756
Starting Member
2 Posts |
Posted - 2008-05-13 : 16:20:08
|
| it's about 24 million rows, 6.5 gigs. |
|
|
|
|
|
|
Import data problem