How do you connect to multiple databases using knex.js?

Question

There is a process that takes data from one database and replicates it to another. They are on different db platforms. It is intended that knex.js be the middleware. This works under 0.10.0

var first = require("knex")(...);
var second = require("knex").initialize(...);

but complains that initialize is deprecated. Can someone give an example of how to do this in the current version of knex.js?

Answer 1

Why don't you use same syntax as for first? I guess that .initialize is just outdated(deprecated) version of just function call.

var first = require("knex")(firstConfig);
var second = require("knex")(secondConfig);

first.select('*').from('users');
second.select('*').from('table');

And you have 2 different builders (each with different config).