Kalo seneng pake command line, coba ini deh : bcp.
The *bcp* utility bulk copies data between an instance of Microsoft SQL
Server 2005 and a data file in a user-specified format. The *bcp *utility
can be used to import large numbers of new rows into SQL Server tables or to
export data out of tables into data files. Except when used with the *
queryout* option, the utility requires no knowledge of Transact-SQL. To
import data into a table, you must either use a format file created for that
table or understand the structure of the table and the types of data that
are valid for its columns.
*bcp* {[[*database_name**.*][*owner*]*.*]{*table_name* | *view_name*}
| *"**query**"*}
{*in* | *out* | *queryout* | *format*} *data_file*
[*-m**max_errors*] [*-f**format_file*] [*-x*] [*-e**err_file*]
[*-F**first_row*] [*-L**last_row*] [*-b**batch_size*]
[*-n*] [*-c*] [*-w*] [*-N*] [*-V* (*60* | *65* | *70* | *80*)] [*-6*]
[*-q*] [*-C* { ACP | OEM | RAW | *code_page* } ] [*-t**field_term*]
[*-r**row_term*] [*-i**input_file*] [*-o**output_file*] [*-a**packet_size*]
[*-S**server_name*[*\**instance_name*]] [*-U**login_id*] [*-P**password*]
[*-T*] [*-v*] [*-R*] [*-k*] [*-E*] [*-h"**hint* [*,*...*n*]*"*]
Semoga membantu...
- setiaji -
2009/12/23 Irfani Firdausy <[email protected]>
> Dear All,
> saya punya permasalahan begini :
> saya punya mssql server dengan ip 192.168.2.1, kemudian saya coba
> query dan hasil query saya masukkan dalam table temporary dengan nama
> table tbltempdump
> dari hasil table tbltempdump saya eksport ke mssql server lain dengan
> ip 192.168.2.5 dengan cara export data manual di sql server management
> studio.
> Bagaimana caranya supaya ostomatis eksport bisa dikasih timing
> misalnya otomatis eksport dari 192.168.2.1 ke 192.168.2.5 setiap 1
> jam, kira2 bisa nggak yah
> kata temen2 sih pake trigger gitu, tapi saya masih bingung gimana caranya.
> Mohon Sarannya.
>
>
>
> Regards, || ~Irfani Firdausy~ |||
> Y! : irfani_f
>
>
>
>
>
> ------------------------------------
>
> ================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY
> <================
> Posting : [email protected]
> Archive : http://www.mail-archive.com/[email protected]/
> www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id
> ************************************************************************************Yahoo!
> Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
