Our user's group had our first Breeze presentation this week. Not having any experience with Breeze (other than attending several Breeze presentations), I was a little nervous about what trouble we would run into.

As it turned out, the set up was really easy and the presentation went off without a hitch.

More significantly, however, Peter Farrell did a really good presentation. He presented on source control software (mostly on subversion - but the presentation was a good overview of available options). He has a good voice for presenting and his pace and demeanor were perfect for an online presentation.

I have not been using a version control system and even after the presentation I am not sure that I will. I am sure, however, that I will at least look into it and weigh my options very seriously. Before hearing the presentation, I wasn't really sure where to get started on making that decision. Now I feel like I have a good starting point for investigating the possibilities.

If you are in a users group that is in a smaller market (Tulsa isn't quite Dallas or NYC), a Breeze presentation is a great way to get presenters and presentations that you might not otherwise be able to get.

Charlie Arehart just covered Breezos for user's groups in his blog , so you might want to read more about it there if you are interested.

Since I work at home and don't have an iPod (the shame!), I have only listened to one or two episodes of ColdFusion Weekly . After this presentation, I will be sure to find a way to listen to more of them. 

In order to test some code for a recent project, I needed to have the data from the live site on my local computer. Of course, the live site is running MySQL which I don't have on my local computer.

By happenstance, I had just read a blog entry on transfering data from an Access to a MySQL database. It looked like a good solution (it uses DataMgr, it must be good!). Unfortunately, the solution listed only works if both databases have datasources on the same computer - not the case for me (though in retrospect I may have been able to set up a datasource on my local computer that pointed to the remote MySQL database).

In any event, I ended up building a tool to handle database synchronization. It will copy a database structure (and data unless you opt not to copy that) from one datasource to another.

This can be done one of two ways.

One: 

1. Load the DataSynch.cfc and pass in the DataMgr for the source database.
   
2. run the getXml() method of DataSynch on the desired tables.
3. Take the resulting XML and pass it into the loadXML() of another DataMgr (this can be on another server running another database)

Two:

1.  Load the DataSynch.cfc and pass in the DataMgr for the source database.
2. Call the addDataMgr() to pass in a DataMgrto which structure (and data) should be copied (this can be done multiple times, creating multiple recievers for structure anddata)
3. Call the synchTables() method of DataSynch on the desired tables to synchronize the database structure and data with the datasources of each DataMgr pass in via addDataMgr()

Note that this approach won't update any existing data. The synchronization is one-way only (from the source datasource outward).

One other advantage to this approach is that DataSynch will do its best to figure out foreign keys. Instead of copying foreign keys by value, it will copy them by look-up (making sure that the value matches the primary key of the related record with the same data).

So, if you have a "categories" table with a catid field as an identity primary key field, the values created in the new table may not match the value in the old table. DataSynch will create the table so that it uses the new value for the catid field of your products table (assuming both are being synchronized) instead of the old value.

To borrow Michael's example. Here is how it could be implemented usign DataSynch:

Because of the nature of DataMgr, any new tables or columns will automatically be created in receiving datasources. 

DataSynch is free and open-source. It requires DataMgr , which can be downloaded from the same page.