Replicate from SQL to a file

#1

Is it possible to replicate from a SQL Server to a file ? I would like to
set up trans replication from a table to a file

#2

No, you could have a trigger on the subscriber write to a file or use
sp_browsereplcmds to do something like this.

I think the tools you are looking for are called bcp, or SSIS, or DTS.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Hassan" <Hassan (AT) hotmail (DOT) com> wrote

Quote:

Is it possible to replicate from a SQL Server to a file ? I would like to
set up trans replication from a table to a file

#3

No i was looking for replication, as I was looking for a near real time
propogation of data from SQL Server to a file.. Crazy requirement, but
something I've been thinking of..

"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> wrote

Quote:

No, you could have a trigger on the subscriber write to a file or use
sp_browsereplcmds to do something like this.

I think the tools you are looking for are called bcp, or SSIS, or DTS.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Hassan" <Hassan (AT) hotmail (DOT) com> wrote in message
news:u5NSOPWGHHA.1216 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Is it possible to replicate from a SQL Server to a file ? I would like to
set up trans replication from a table to a file

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Replicate from SQL to a file

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication

Replicate from SQL to a file - 12-06-2006 , 12:24 PM

Re: Replicate from SQL to a file - 12-06-2006 , 12:39 PM

Re: Replicate from SQL to a file - 12-07-2006 , 01:38 PM