Dear w2p users, I want to move all my db data from sqlite to postgresql. Based on the w2p book I need to use cpdb.py script. I have used it and get positive messages but I have not got any db changes in postgresql.Any idea why it does not work? Any advice would be very appreciated!
Below is my work path: 1) I have tried to use cpdb.py script. It did not work from the scratch as I have to installed readline module but as my OS is windows 7 I have to installed pyreadline instead and add following change in cpdb.py: try: import pyreadline as readline except ImportError: import readline 2)I have created brand new db in postgres. 3)I have tried to copy data from 1 db to another by following cmd: c:\Users\power\PycharmProjects\test_test\web2py>python scripts/cpdb.py -d gluon -f applications/app/databases -y sqlite://dbs.sqlite -Y postgres://postgres:avh 1981@localhost/idna_dbs1 -t False 4)It gave me following results: gluon path not found creating tables... exporting data... importing data... done! Attention: do not run this program again or you end up with duplicate records 5)But I have got nothing in my postgresql db! Any idea why it does not work? Any advice would be very appreciated! Thank you in advance. Andrey -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
