-
Copy table to another server
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.
74SYL
-
Create linked server and you can copy table with 'inster ... select ... from ...' via linked server.
-
Thanks for idea, rmiao. I already tried in this way but "insert ..." 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?).
-
All this time the solution was under my nose. SSIS pakage can do the required job. It works great!
Thanks again rmiao!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|