Complicated SQL Replication Question

Running replication over FTP via a web server

[Krapulator]

We have two sql servers which cannot be connected directly to each other. We wish to use replication via a web server (which both of the sql servers have ftp access to).

However when trying to set up the ftp location for replication in sql it will only accept local network references (EG \\hostmachine) it will not accept an ftp location (eg ftp://hostmachine) and it is not possible to map an ftp server as a drive in windows 2000.

Is there a way we can run sql replication for these two sql servers via ftp to the webserver?

[bakedjake]

Dump the DB locally and then write a WSH script to FTP the file at an interval of your choosing to the webserver.

[plumsauce]

maybe you could assign the desired name in the lmhost file to let you resolve the assigned netbios name. any machine destination is just a pairing between the ip address and the naming scheme. in this case, they want to use the netbios name. the lmhost file will let you supply it.

oh, another way of specifying a netbios name by ip is:

\\192.168.0.1

for example.