DBSync for MySQL and DB2 is a database synchronization tool which performs two-way conversion and synchronization from MySQL databases to DB2 and from DB2 to MySQL. The tool is also applicable for MySQL database replication to another MySQL database and is quite adept at copying DB2 to another DB2 database.DBSync for MySQL and DB2 provides the bulk of functional capabilities such as interactive (GUI) mode / command line mode, CLOB, BLOB DB2 data types smooth conversion to MySQL types, insert, update and drop synchronization types, advanced customization options, ability to save sessions for further use, flexible task scheduling with built-in scheduler, data filtering, preverification of possible conversion errors, etc.You can convert and synchronize MySQL with DB2 or DB2 with MySQL simply by configuring several options and by making some sync customizations through a Wizard interface or in command line mode. Command line parameters added to a scheduling function enables you to automatically synchronize or convert data regularly without user input and supplementary settings.Insert sync is meant for adding new records from a source to a destination. Update sync is intended for replacing the altered records in a destination db. Drop sync type allows users to delete records from a destination db if these records were removed in the source. Update, Insert and Drop synchronization together allow keeping distributed databases in agreement.DBSync for MySQL and DB2 provides you with the ability to manipulate synchronization preferences on Customization stage exactly according to your needs.Filtering data during conversion allows users to retrieve only specific data for converted tables according to defined filtering criteria. Filters give you more control on the data migration process.Possible synchronization errors can be detected before the conversion process gets started. The tool displays potential problems with your table objects beforehand.Note: You require a functioning database for the program to function correctly.

CrystalDiffract is a tool developed to simulate x-ray and neutron powder diffraction patterns from CrystalMaker binary files - or directly from CrystalMaker via a menu command.Detailed measurement, indexing and manipulation of diffraction patterns is possible in real time, with extensive control over diffraction parameters. CrystalDiffract works with CrystalMaker, reading from saved crystal files to simulate and display powder diffraction patterns on screen. You can drag-and-drop a crystal file into CrystalDiffract, or use CrystalMakers Transform > Diffraction Pattern > Powder command to obtain a diffraction pattern for any displayed crystal structure. Diffraction patterns can be displayed as traditional greyscale "films", or as diffractometer traces (graphs of intensity versus two-theta, d-spacing, 1/d, time-of-flight or energy). Tools allow you to measure peak positions, intensities, and their Miller indices. You can precisely scroll the diffraction pattern, or select a plot range and zoom. Other tool buttons provide scaling functions, as well as x and y-axis offsets. Anyone with real diffraction data will find CrystalDiffract invaluable for data analysis - not to mention the mundane job of indexing diffraction peaks. The ability to simulate mixtures makes it easy to test multi-phase assemblages - and you can even estimate phase proportions by adjusting the volume fractions for your individual components in real time!CrystalDiffract lets you control all aspects of a diffraction experiment. You can start by choosing x-rays or neutrons, then specify wavelengths, selecting monochromatic or dual-wavelength radiation. You can pick a diffraction peak function, edit the instrumental peak broadening, sample strain and size effects (full version). You can also edit site occupancies - perhaps to investigate the effects of structural disorder on a diffraction pattern - and even exclude selected sites from the diffraction calculation. You can drag-and-drop a large number of CrystalMaker files into a windows Structures List, and then quickly browse individual diffraction patterns by selecting entries from the list. This is invaluable when trying to identify an unknown phase.