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 |
|
silpower
Starting Member
3 Posts |
 Posted - 2010-12-06 : 12:25:36
|
| Hi all,Does anyone know if there is possible to copy table from a DB in server 1 to a DB in server 2, just like in Import/Export Wizzard but through a script job? Server 2 is "hot" and I am not allowed to use BCP to execut a job locally on Server 2 to import data, but only to export data from Server 2 to Server 1.I need to know what is the instrument that could do this job.Thanks in advance.silpower |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
silpower
Starting Member
3 Posts |
Posted - 2010-12-07 : 04:54:56
|
| Thanks for idea, Brett. I already tried in this way but "insert ..." via linked servers creates logs on Server 2 and this is unacceptable. I just need to schedule Import/Export Wizzard to copy a table from Server 1 to Server 2 at a specified time. Or to put in a script job what the Wizzard actually does.Because Import/Export Wizzard is the only way which doesn't affect Server 2, according to my observations (or maybe is there other way?). |
 |
|
|
silpower
Starting Member
3 Posts |
Posted - 2010-12-07 : 07:29:33
|
| All this time the solution was under my nose. SSIS pakage can do the required job. It works great! Minimum impact on Server 2.Thanks again! |
|
|
|
|
|
|
Copy table to another server