[jira] [Commented] (SYNCOPE-1540) Make internal storage export DBMS independent

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SYNCOPE-1540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17068596#comment-17068596 ] 

ASF subversion and git services commented on SYNCOPE-1540:
----------------------------------------------------------

Commit 79547f26cab2027102c4f782fd77b6611dc2c935 in syncope's branch refs/heads/master from Francesco Chicchiriccò
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=79547f2 ]

[SYNCOPE-1540] Skip exporting SYNCOPE_AUDIT table


> Make internal storage export DBMS independent
> ---------------------------------------------
>
>                 Key: SYNCOPE-1540
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-1540
>             Project: Syncope
>          Issue Type: Improvement
>          Components: core
>            Reporter: Francesco Chicchiriccò
>            Assignee: Francesco Chicchiriccò
>            Priority: Major
>             Fix For: 2.1.6, 3.0.0
>
>
> [Internal storage XML export|http://syncope.apache.org/docs/2.1/reference-guide.html#export] is an appreciated feature allowing developers to port configuration across environments.
> Unfortunately, the generated XML is DBMS-dependent - meaning that H2 outputs table and column names all uppercase, PostgreSQL all lowercase and so on.
> This makes the exported XML document not immediately portable across different databases and manual edits are often needed.
> Note that the XML documents in the source tree (used for internal storage bootstrap= do not suffer from such a limitation, hence we should ensure that export feature generates following the same conventions.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)