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 |
|
nahmed
Starting Member
2 Posts |
 Posted - 2004-05-11 : 04:11:32
|
| Hi,I am importing database from teradata to sql server using import/export of sql server but its taking too long. e.g taking 5 hours to import 230M of database. Please suggest if anybody knows the way to improve this performance or any alternate way for this.Immediate help would be appreciated.NAD |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-11 : 07:59:46
|
| Use bcp. You can find information about it in Books Online. It's the fastest protocol to transport large amounts of data between database servers. You can also search this site for all kinds of examples.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
DTS Import slows down.