April 2, 2002 at 2:10 pm
Hi, I am a newbie to SQL replication.
Here is my situation,
I have a catalog database at home machine (SQL2000). I also have a SQL host somewhere on the internet. At present, I keep the "pulisher" at the host, and continue to import data using DTS to my home machine for back up. Sometimes, it is painful if I forget to import it for a week.
I just learn little bit about the data replication. It sounds like I would keep the publisher at home, and replicate data to the host. Using my home DSL, I can set up my home server to monitor and back up data from my host at any time. Is this possible???
Also, I want to share my data to other websites owned by different owners. How can I let them share my data without letting them to know my host connectivity?????? or not worrying them to copy my data????
PLease help. Thanks
April 2, 2002 at 3:07 pm
Answer one is no, not like you are speaking of, but you could schedule with agent to run the DTS pull every so often. Replication requires the server to be setup as a publisher so you can subscribe to it.
Question 2, can you setup user accounts within you DB that are limited? If so this is how you would do it, (preferably thru stored procedures to protect tables). If not then you may not have an option and I suggest ask you provider.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 3, 2002 at 2:58 am
You could use your home machine as the publisher. Your host maching would subscribe to the published tables. Any changes made to tables at either end would be synchronized.
(merge replication)
Next question:
You can use a push subscription to connect to the other websites. You can publish specific data and have different publications to the other servers. They do not need connection information to your servers. Your server will need to have their connection information ( i.e. IP address)
Good Luck
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply