Wednesday, June 11, 2003, 3:59:51 PM, you wrote: >>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.
Let me modify this...whichever side I control is the side that has the DTS. It could be that I controlled the side being published too, in that case, it becomes a pull transaction instead of a push. DH> Wow, well said; thank you for taking the time to help me understand this. I DH> always thought DTS was used to migrate databases, or transfer data between DH> disparate data sources. I didn't realize it was useful for making small DH> batch updates. Yeah...just schedule the DTS, and you never have to touch it again, and modifying it is point and click. DH> I had already run into the schema problem you mentioned with replication DH> since my primary keys are identities. DH> But why don't you recommend FTPing the updated database files? Is that some DH> kind of SQL Server no-no? If so, why? It would definitely be possible to do this by disconnecting the detaching the db and uploading and reattaching, or by uploading a backup, or even uploading a flat file and importing it, or some other way, but all those adds steps, and possible points of failure. None are totally unacceptable, they just wouldn't be my choice. Other than importing a flat file, the other two have downsides as well. Like the phantom user issue... -- jon mailto:[EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4