Hi Gary, > Hi People, > > Vaughan posted earlier this week about adding a rowGUID to tables in > FarCry and what the implications of this may be for updates. > > Aside from other reasons why we want to do this, we have a need to > replicate the FarCry database to our back SQL*Server. The process of > activating replication will cause a rowGUID field to be added to EVERY > table. > > We would like to know if anyone has done this and if any consideration was > given to the ramifications of doing this or if there were any issues > encountered.
We setup snapshot replication in SQL 2000 for Australand and there was no problem with the extra GUID field that's created. The main issue to be aware of is trying to replicate identity columns. You can filter out writes to identity columns when setting up replication but this won't help if you've got any tables with foreign keys that reference the identity columns. By default, none of the core FarCry tables have identity columns but we'd added a few tables that had them. The easiest way around it was to change the identity columns back to non-identities and just do a SELECT MAX(ID) before inserting new records (inside cftransaction to keep the operation atomic). Another thing to lookout for is copying related files and images. If you're just backing up your db it's not a problem, but if you want full site replication you'll need to copy over the files and images that tables like dmImage point to. Otherwise you end up with broken images and file links. You'll also need to think about cache flushing and regenerating Friendly URLs (if you use them) if you're replicating the site. Hope that make sense! Tim --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
