fastfish wrote:
I have a split db that on the dev versions w/ test data in the tables i
have edited the relationships.
Is there a way to move the relationships I have created in the dev db
to the production db?
Yes it can be done. You'll need DAO to iterate through the existing relationships and save
them somewhere (perhaps a Collection or array). Then in the production database remove all
realtionships using the DAO Relations collection. Then add the ones in the Collection from
your test db.
Sounds easy heh? There are some issues to be aware of like deleting relations from the
back of the Relations collection to the first. You'll want to preserve the relationship
type (Cascade, enforce referential integrity, etc.) and handle the probable error where
the production database can't implement the relationship (.CreateRelation()) or the field
isn't indexed, etc.
Do lots of testing....
Good luck.
--
'---------------
'John Mishefske
'---------------