Just schedule the DTS package to run at certain times.. :-) You should be fine with that approach. You can always execute the package prior to meeting with a client, thus giving you the current information only when needed.
Mike -----Original Message----- From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 9:12 PM To: SQL Subject: RE: Replication Hi Michael, > Evaluate your need for the data. Do you need to develop > against the most current data? What is wrong with your DTS > setup now? Are you just interested in learning ore about replication? It's both, really... It's actually for the Perth International Arts Festival (http://www.perthfestival.com.au), they have a content management system, and the site is still under quite heavy development, with daily content updates. Whenever I show them new functionality, I do it on our local copy of the site. Having up to date data is not critical, but when you're dealing with non-technical people it's just easier for them to grasp, especially if the new functionality has been designed especially for new content. I'm sick of explaining "that's ok, when we go live, all your new data will be there...". Plus, replication sounds cool. Don't mess with THE REPLICATOR. > Snapshot replication is less taxing than transactional > replication but still taxing nonetheless and provides no > greater advantage over DTS in YOUR situation based on what > you told us so far. Hmmm... By taxing, you mean taxing on the remote (live) server? Because I don't want to be a burden on the shared hosting, my host might stop being so nice to me :) Or taxing on the subscriber, or bandwidth, or all of 'em? > I disagree with snapple... replication and triggers are not > for you... I say stick with DTS and grab the data once or > twice a day at low traffic times. My main concern was to automate the process, mostly out of laziness. I could set up DTS scripts though, couldn't I... That would probably be smarter than doing it manually, as I do now. Thanks for your advice! Kay. _____________________________________________________________ Kay Smoljak Web Developer PerthWeb Pty Ltd Level 9/105 St George's Terrace - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 http://www.perthweb.com.au http://developer.perthweb.com.au ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1735 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
