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 |
|
ramu143
Yak Posting Veteran
64 Posts |
 Posted - 2008-06-25 : 08:44:44
|
| Hi All,i want to copy table from one server to another server..each table having more than 20laks row....I want to copy only 7 table to another serverNow iam exproting the data through DTS Pakages..But it more than 10 hours....Regards,Naveen |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-25 : 08:57:39
|
| Try configuring the two servers as linked servers and using OPENQUERY. |
 |
|
|
ramu143
Yak Posting Veteran
64 Posts |
Posted - 2008-06-25 : 09:35:23
|
| open query |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-25 : 09:39:00
|
quote:
Originally posted by ramu143
open query
http://msdn.microsoft.com/en-us/library/ms188427.aspx |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-25 : 09:53:51
|
| Also, see if you can bcp out to text files in source server and bulk insert into the target serverMadhivananFailing to plan is Planning to fail |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-25 : 12:57:20
|
| Use Export/Import wizard. |
|
|
|
|
|
|
Help in import