View source | View content page | Page history | Printable version   

Projects:Wildcard Support In Exclude Filter

Contents

Introduction

Openbravo uses SymmetricDS as the tool to handle the database synchronization between the central server and the store servers. This tool creates several database objects (tables, triggers, functions and sequences) that should be ignored by dbsourcemanager when doing import/export.database.

Normally this would be handled by the exclusion filter, but there are two problems:

The aim of this project is to support using SQL wildcards in the exclude filters, so that there is no need to add an exclusion clause per excluded database object. For instance, to exclude all the tables whose name starts by "SYM_", the following exclusion clause could be used: <excludedTable name="SYM\_%"/>

Exclusions will be handled as wildcards if its name contains the '%' character.

This issue will also benefit from this project if it manages to escape properly the underscore character in Postgres and Oracle.

Phases of the project

The project is going to be divided in four phases:

Tracking issues:

Documentation

User Documentation

Included here.

QA & Tests

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Wildcard_Support_In_Exclude_Filter"

This page has been accessed 1,262 times. This page was last modified on 7 January 2016, at 13:57. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.