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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2008-03-23 : 18:46:34
|
| Hi Guys,What is the fast way to move huge table (77 million) records with 25 columns across servers? The servers are not linked though.Thanks for the help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-23 : 19:09:10
|
| Try using OPENROWSET |
 |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2008-03-23 : 19:30:03
|
| How can we export sql data in unix format ... I need to send the files to be imported in mainframe and they told me it should be in a specific way... gave me bcp script that did not work so thinking about doing it using dts.... wat should be my delimeters and what should be file like? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 19:34:37
|
| What kind of unix format? |
|
|
|
|
|
|
Fastest Way to move huge table across servers