|
Home > Archive > SQL server exams > May 2002 > replication problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
replication problem
|
|
| mchoirul 2002-05-27, 8:52 pm |
| I have real problem with my job :
My company just opened a branch office. We have sales application installed with SQL 7 backend and Access 2000 front end in the head office. I want to install this application on the remote office. How I can set up database replication between them ? My idea is put MSDE on remote office & sales app front end, and setting up replication with SQL7 that reside on the head office. I will use RAS server with dial up telephone to do this.
Is anyone in this forum has experience about this ? Share with me | |
|
| quote:
Originally posted by mchoirul
I have real problem with my job :
My company just opened a branch office. We have sales application installed with SQL 7 backend and Access 2000 front end in the head office. I want to install this application on the remote office. How I can set up database replication between them ? My idea is put MSDE on remote office & sales app front end, and setting up replication with SQL7 that reside on the head office. I will use RAS server with dial up telephone to do this.
Is anyone in this forum has experience about this ? Share with me
I don't have a huge amount of experience with this, but I'm in a similar situation (need to replicate from SQL 2000 to Access 2002).
From what I gather in MSDN, it shouldn't be a problem setting up replication between SQL and Access. Dunno if you can get MSDE to act as a publisher or distributor tho, I doubt it... | |
| necrophantasm 2002-05-31, 11:44 am |
| Unfortunately, I am not using SQL 7. We are using 2k on 2k servers, so I am not sure if you will be able to set this up the same way I am. The way I got around this issue was to set up a PPTP VPN server on the Publisher, then just configure a client connection on the subscriber machine (I am not sure if you will be able to set up the full VPN access in Windows NT RRAS, I never tried). Once the VPN was set up and in use, I was able to register the remote server in Enterprise Manager and configure it as a subscriber of the databases I wanted replicated. If you want more details on how to set up the replication process itself, let me know and I will do my best to answer your questions. Hopefully my strategy will give you a couple of ideas though. Good luck! |
|
|
|
|