I've found out the best way is usually determined by the circumstances. How much does a client want to pay...how technical is the other side, do you want realtime, pseudo-realtime, or batched updates, firewalls, etc.
In my perfect world though, in a batch situation, with a small update, the publishing side would fire a DTS that connected to the remote side and updated the data. This one takes very little time to setup, and doesn't place the constraints that replication does on the schema. It also can be done manually or automated, so it's flexible. -- jon mailto:[EMAIL PROTECTED] Wednesday, June 11, 2003, 3:12:04 PM, you wrote: DH> Hi all, DH> Can someone explain? Is it better to use DTS, replication, or FTP to update DH> SQL Server 2K database files on a shared host? (The database is small; there DH> will only be about 50 new records each week.) DH> TIA, DH> ~Dina DH> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
