Refreshing your Verity collections would probably also be a good thing, if you hadn't already considered that.
Nathan Wheat Technical Sales Consultant Firmware Design Phone: 0401 148 989 Email: [EMAIL PROTECTED] http://www.firmware.com.au Save thousands on your Web site budget! Find out how a Content Management System can reduce Web maintenance costs: http://go.firmware.com.au/cms/ft -----Original Message----- From: Richard Ragan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 19 December 2001 5:52 AM To: Spectra-Talk Subject: Re: Publishing a CODB to a production site > We have two Spectra sites set up, one for development, and one for production. We want to do all of the changes on the development > site and have the cob published to the production site every night. But we have a discussion board on the site, so the publishing > must include everything except two object types. What is the easiest (read: non-wddx) way to go about this? Both codb's are on a > single SQL Server 2000 installation. I've taken a look at doing a SQL Server publish, but something tells me that it would be more > complicated than just excluding all the objects of those two types from the objects table. Though I have never tried it, the SQL server publish looks, to me, like your best non-WDDX bet. You can filter out the two types when you use the publish wizard by doing a horizontal filter and excluding records based on typeid value. You need to be careful to publish the extendeddata table as well since this contains parts of objects > 65K in size. If all you are doing is adding content and not working with versioning, then replicating the objects and extendeddata tables will get your content moved. If you use any Spectra metadata or the properties table you will need to replicate it as well. After a publish, you ought to discard all caches on your production box since objects may have been updated. Did I miss any key tables for content, gang? Rich ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
