Using DTS to sync Remote Database to Local Machine
I hope someone can help. I have a SQL 2000 database that is hosted through a company which allows minimal management due to security reasons. This database is where all of my data from multiple domains is being managed. I have SQL Server 2000 also running locally and I want to synchronize my local machine with the remote as best I can. I am told that I can use DTS in order to import/export the remote into my local server. My questions and concerns are this:
1) - first off, what is the best way to set this up so that any table changes/additions are copied locally if need be. There were updates occurring on the hosted tables often so I want the local copies to be updated with records and changes just the same.
2) - How can I set this up to occur peridoically when I desire - say, 3 or 4 times per day.
I have not had to manage a remote database like this before so I want to ensure I am doing it correctly. If even a few times a day my local machine can automatically be updated with the current remote data and definitions that would be great.
I apprecaite any help in advance - thanks.