> Thanks for taking a second look. What about database changes, how
> would they get synced?


Well - as far as schema is concerned - Daemon produces an UPDATE script with
every new release of FarCry.  You would need to temporarily upload the
update script files along with the codebase changes and run the update on
the remote server.  You may also need to run the DEPLOY options in the Admin
Console (each release will tell you if you need to or not) to sync any
changes to the database objects with any code/schema changes.  The tool is
very friendly and shows you what is out of sync and why.  You then have
options to tell it what to do.  Remember to remove the update/install
scripts when you are finished.

If you are building your own FarCry objects the tool will also interrogate
these using the same mechanism (so I strongly suggest learning more about
the FarCry object framework as soon as you can).  If you are familiar with
CFMX and CFC's and things like inheritance - you are well on your way.
Otherwise, cover some of this first before building objects using the FarCry
framework - but it is very powerful once you understand it all.

There is documentation on the FarCry site - but, when the coders are also
the documenters and "the people" want features, it is sometimes hard to keep
the documentation up to speed.  That is where looking at what the code does
(without chsnging the core) is often the quickest route to an answer - as
well as pushing questions to this list.

As far as changes to "data" in the database is concerned you would probably
have to look at a mechanism of scripting this yourself (unless your provider
allows you to run SQL Enterprise Manager - if you are running MS
SQL*Server - in which case you could create DTS packages to synchronise or
possibly use some form of replication).  If you are using mySQL and
something like phpMyAdmin then you would simply have to have a mechanism of
knowing what data had been added locally and get a script generated from
your local mySQL tool and then running that on the remote environment.

In re-reading the above paragraph there may be market for a database sync
tool for FarCry.  It would require secure enquiring of the server as to what
data it had and getting that back as XML.  Then the local machine would
package up data changes in XML and post them back to the server to execute
against the database (the danger would be intermediate changes that may
happen between the download/process/upload cycle - better known as
replication conflicts).  But it could be done.

Then there are "files" that you may have uploaded through as a dmFile or a
dmImage.  These would be the trickiest to sync because there is a DB
component (the database record) and an OS component (the file in the file
system).  You could use a similar process to the replication one I mentioned
above.


Hope some of this helps.

Regards
Gary Menzel

[PS - some initial comments on our environment to follow this post]




---
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

Reply via email to