Windows Forum

Ask something
Discussion Locked

Replication using modem in SQL server7.0

0 helpful
6 replies

by radhakrishnan_seetharaman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have problem in connecting two Nt servers through telephone line. We are not able to get the Remote server in our network neighbour. But we are able to login to the remote server after connecting. We are also not able to do replication using telephone line. Can anybody suggest? solution

6 replies

by mostakim

What protocol u r using? try netbios with tcp/ip, install routing and remote access software (mpri386.exe)on NT server. Workgroup name and domain name must be the same if u want to see the computer in your Network Neigh: first you have to make sure that u can ping the server and check the host name resulation; the command is
" ping -a xxx.xxx.xxx.xxx " with this command you can see the name and IP of that server, please conact for more detail info.

by E.Eliveld

Hi,

If I understood your problem correctly I have done soemthing similar.

If your goal is to replicate/merge the SQL database you can use the snapshot replication.

Suppose box a (the remote one) creates a snapshot every night and places this into a directory whith a ftp server on top of it. (You can start the ftp server for a period of time after the creation of the snapshot.)

During the morning box b (the local one with the valid SQL base) uses a ftp client to get the snapshot over. The sheduler inside SQL lets you merge the downloaded snapshot into the local SQL base.

Good luck!

by radhakrishnan_seetharaman

Even though the answer is not directly connected to our problem (just connecting two NT servers with Telephone line) we have got some inputs in doing replication with SQl server.

This discussion is closed to new replies.