Hello,

kamcli tool is a good candidate for such feature, it is python and quite modular:

- https://github.com/asipto/kamcli

Adding migrating db feature was one of my goals for this tool, but lack of time didn't allow me to dig much into python, as I am not using this programming language that often. Maybe others can jump on board and help here.

Cheers,
Daniel

On 02/03/16 18:21, Tim Chubb wrote:

As a suggestion for 5.0 having a scripted DB migration system would make upgrading much easier.

Something like what Asterisk now uses (Alembic https://pypi.python.org/pypi/alembic) would be ideal, as it works in a DB agnostic manner and you would just have to ensure that there is a driver for the DB you wish to use.

That way you would just update the definition script and select the target when you run the updater, and would allow kamailio a greater choice in backing DB’s as once the script is written assuming a driver is available for you RDBMS the schema would be successfully ported.

This would do away with maintaining separate MySQL, Postgres, Oracle, MSSQL scripts as well.

The only issue I can think with a system like this is in the situation where hardcoded SQL strings are in the source and use a RDBMS specific function as that could cause some “fun” in debugging…
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, March 7-9, 2016 - http://www.asipto.com