dimanche 5 juillet 2015

Trying to migrate data from sqlite to postgresql with taps

Im trying to migrate my database from sqlite to postgresql so I can deploy to Heroku. Im using the gem 'taps' like shown in this railscast However, when I run the the taps command to host my sqlite db but I keep getting a Database Connection Error.

From the command line:

$ taps server sqlite://db/development.sqlite3 username password
C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/adapters/sqli
te.rb:62:in `initialize': SQLite3::CantOpenException: unable to open database fi
le (Sequel::DatabaseConnectionError)
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
adapters/sqlite.rb:62:in `new'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
adapters/sqlite.rb:62:in `connect'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
database/misc.rb:45:in `block in initialize'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool.rb:92:in `call'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool.rb:92:in `make_new'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:126:in `make_new'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:112:in `available'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:102:in `block in acquire'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:146:in `block in sync'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:146:in `synchronize'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:146:in `sync'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:101:in `acquire'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
connection_pool/threaded.rb:74:in `hold'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
database/connecting.rb:226:in `synchronize'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
adapters/sqlite.rb:94:in `execute_ddl'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
database/schema_methods.rb:320:in `create_table_from_generator'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
database/schema_methods.rb:94:in `create_table'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
plugins/schema.rb:24:in `create_table'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sequel-3.20.0/lib/sequel/
plugins/schema.rb:33:in `create_table!'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/taps-0.3.24/lib/taps/db_s
ession.rb:20:in `<top (required)>'
        from C:/row/Ruby2.1.0/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb
:55:in `require'
        from C:/row/Ruby2.1.0/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb
:55:in `require'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/taps-0.3.24/lib/taps/serv
er.rb:4:in `<top (required)>'
        from C:/row/Ruby2.1.0/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb
:73:in `require'
        from C:/row/Ruby2.1.0/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb
:73:in `require'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/taps-0.3.24/lib/taps/cli.
rb:61:in `server'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/taps-0.3.24/lib/taps/cli.
rb:27:in `run'
        from C:/row/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/taps-0.3.24/bin/taps:6:in
 `<top (required)>'
        from C:/row/Ruby2.1.0/bin/taps:23:in `load'
        from C:/row/Ruby2.1.0/bin/taps:23:in `<main>'

Aucun commentaire:

Enregistrer un commentaire