Convert a SQL script to SOPM DatabaseInstall

English! place to talk about development, programming and coding
Post Reply
juanman80
Znuny newbie
Posts: 44
Joined: 11 Nov 2011, 10:30
Znuny Version: 5.0.15

Convert a SQL script to SOPM DatabaseInstall

Post by juanman80 »

Hi,
I’m developing an OTRS Module which creates a database table and modifies some others (a custom statistics module, just adding some control information and data so I don’t have to redo every calculation).
I’ve developed it in my DEVELOPMENT environment and I want to make a package to test install it in my PREPRODUCTION environment.
Now I face the challenge of converting my SQL script to XML and insert into my SOPM file.
Anyone has a custom tool or script that makes this conversion? If not, is there any Backus-Naur style notation for the grammar needed in the SOPM file?

Kind regards,
Juan Clavero
OTRS 5.0.15 on CentOSLinux with MariaDB database connected to an Active Directory for Agents and Customers.
Post Reply