Re: DTS to update SQL Server database?
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm -- mailto:[EMAIL PROTECTED] Wednesday, June 11, 2003, 7:33:26 PM, you wrote: >> Other than importing a flat file, the other two have downsides as >> well. Like the phantom user issue... DH> Phantom user issue? 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DTS to update SQL Server database?
> Other than importing a flat file, the other two have downsides as > well. Like the phantom user issue... Phantom user issue? ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DTS to update SQL Server database?
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
Re: DTS to update SQL Server database?
>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. Wow, well said; thank you for taking the time to help me understand this. I always thought DTS was used to migrate databases, or transfer data between disparate data sources. I didn't realize it was useful for making small batch updates. I had already run into the schema problem you mentioned with replication since my primary keys are identities. But why don't you recommend FTPing the updated database files? Is that some kind of SQL Server no-no? If so, why? ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DTS to update SQL Server database?
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
DTS to update SQL Server database?
Hi all, Can someone explain? Is it better to use DTS, replication, or FTP to update SQL Server 2K database files on a shared host? (The database is small; there will only be about 50 new records each week.) TIA, ~Dina ~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4