On 14 Jun 14:38, NotZippy wrote: > Is there a mechanism for converting a database created with sqlite to > postgres backend? The built in tryton client backup/restore doesn't work, > it appears to back up using the databases internal mechanism.
Yes we did not reinvent to wheels there. > I have been > using this > http://hg.tryton.org/tryton-tools/file/tip/sqlite2pg.py > But there are a number of columns coming from the sqllite database that are > coming across as the wrong type. ie Ints for bool and strings for floats so > far the changes look like the following, Yes, sqlite has very few internal types > but perhaps a better approach > would be is to look at the target tables column types to do the > conversions.. Apparently it is possible to active the default casting of integer to boolean: http://forums.devshed.com/postgresql-help-21/automatically-casting-integer-boolean-632699.html -- Cédric Krier - B2CK SPRL Email/Jabber: [email protected] Tel: +32 472 54 46 59 Website: http://www.b2ck.com/
pgpn8ezn8_Ewx.pgp
Description: PGP signature
