FTP Replication

Is it possible to implement SQL Replication via ftp without expose SQL
Server on Internet.
I mean if SQL Server is in local mashine and only ftp site is visible to the
subscribers.
And i dont want to use VPN
Well you have several options
1) have SQL run on port 21, then get your snapshot over another way.
2) use sp_browsereplcmds to get plain text commands to issue on the
subscriber. This will require a local subscription to generate these
commands.
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
"Greg" <gcholakidis@.hotmail.com> wrote in message
news:d74j04$3pe$1@.usenet.otenet.gr...
> Is it possible to implement SQL Replication via ftp without expose SQL
> Server on Internet.
> I mean if SQL Server is in local mashine and only ftp site is visible to
the
> subscribers.
> And i dont want to use VPN
>
|||I try to implement the second approach (using sp_browsereplcmds).
Unfortunly i see in help that sp_browsereplcmds doesnt work with merge
replication
(in remarks ' sp_browsereplcmds is working with transactional replication')
I dont understand why Microsoft is mention ftp replication since they dont
implement futures which allows
you to use ftp server anywhere in the net and require VPN or SQL Server
exposed to net.
Is there any workoroun or thirt party tool which will allows such
communication?
I mean i need merge replication between two sites. And i want to use ftp
server to store and exchange snapshots.
I have an application which works this way but using Sybase Anywhere
replication and want to convert it to SQL Server 2000
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%2393LawgYFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Well you have several options
> 1) have SQL run on port 21, then get your snapshot over another way.
> 2) use sp_browsereplcmds to get plain text commands to issue on the
> subscriber. This will require a local subscription to generate these
> commands.
>
> --
> 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
> "Greg" <gcholakidis@.hotmail.com> wrote in message
> news:d74j04$3pe$1@.usenet.otenet.gr...
> the
>
sql