What’s New in SymmetricDS 3.1

What’s New in SymmetricDS Pro 3.1

The new release of SymmetricDS 3.1 will help you:

• Dynamically add tables to synchronization
• Migrate and backup data between database platforms
• Save time during configuration and testing
• Filter data through configuration using scripting

Select Tables with Wildcards

Quickly select and dynamically add tables to database synchronization using wildcard characters. Save time during configuration and even eliminate the need to make changes to configuration in the future as new tables are added. Specify data capture triggers as a list of comma-separated tables with wildcard matches.
The most specific configuration is used, so use the flexibility of wildcards and then add configuration for specific tables you want to override. Replicating new tables automatically as they are created can be used to build unique solutions that require the system to assemble itself in response to changes.

Data Export and Import Utilities

The dbexport and dbimport utilities provide a powerful set of options for extracting and loading data using the same core features and flexibility of SymmetricDS. With support for 12 different databases, SymmetricDS is the ideal tool for migrating data from one database platform to another. Data can be exported to files and imported using formats that are independent of the databases being used. Create backups and restore data to move data between environments. Extract subsets of data that you specify and publish it to another system. Add data filters to the import process for custom control of data as it loads.

Data Fill Testing

Test your configuration using the dbfill utility to insert random data into configured tables. By examining data types and sizes, it chooses appropriate data to place into tables. By examining foreign keys, it inserts dependent data in the right order to satisfy constraints. As the data syncs, you can verify that sync direction, options, and filters are performing as expected. Save time during configuration and ensure thorough testing by automating the test data set.

Load Filters Screen

Filter data using BeanShell scripts from a new Load Filters Screen. Use all the power of the data writer filter API from a simple scripting interface. Scripted filters are part of the configuration, so they easily migrate to each environment with the configuration export and import functions. Run the filter for a specific catalog, schema, or table name. Target the filter based on the direction the data is syncing. Examine the data from insert, update, or delete operations to decide whether to modify or filter data. Query for additional data to make decisions or enhance the current row. The new Load Filters screen makes it quick and easy to filter data without writing a Java plug-in.