June 30, 2005 at 5:40 am
Hello
I've one SQL2k at home office and one at the ISP. ISP is at the moment a shared server. What is the best way to keep both servers synchronized. DB at the ISP server will be accessed via webpage and it could be updated via webpage by the visitors - however that's not the main way of updating it. Most updates will be done by a flat file import. I could update SQL and the office and then synch it with ISP server.
All help appreciated - Mark
July 1, 2005 at 2:15 am
What about merge replication?
Bye
Gabor
July 1, 2005 at 8:32 am
replication is a great choice if you can get it implemented at an ISP. Some won't allow it.
I'm a little confused. You say the main way of updating is a flat file import, why not just import things at the ISP server and then pull that data back with DTS or backup/restore, or something to the office. Can you not force all updates from the office to go through the ISP server?
July 1, 2005 at 9:47 am
Steve
All insert/updates will be done at the ISP via a small application that I'm having designed. Since I'm on a shared server I don't think they would give me permission to replicate. I've FTP access - what is my best option to update my office server with the data from ISP server.
Appreciate your help - MArk
July 1, 2005 at 10:51 am
How do you connect your Office SQL to your ISP SQL ?
* Noel
July 1, 2005 at 10:56 am
They are not connected - FTP is the only access I've
July 1, 2005 at 12:14 pm
Do you at least have access to bcp or DTS ?
* Noel
July 1, 2005 at 1:39 pm
Yes - I have access to both.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply