Hi everyone,
I'm looking for thoughts on how to copy fields between databases and I just can't seem to get pointed in the right direction. My problem is that I have two databases, one is newer than the other and has been modified (fields added over time). There is an existing append process that requires that both databases are identical in structure so what I'd like to do is: automatically scan the databases to identify the differences in fields; and, copy those fields that are missing from one database to the other. I'd appreciate any thoughts/ideas on which object to use etc.
cheers