I have (for testing purposes) many dbs with the same schema (=same tables and columns basically) on a sql server 2008 r2 instance. i would like a query like SELECT COUNT(*) FROM CUSTOMERS on al...

I have a problem with my query and I need to join two tables from different databases now my problem is how can I execute my query. I got my syntax format from here Please visit first this link s...

I have 2 databases db1 and db2 in symfony2 + doctrine2 and both databases are different from each other in terms of tables and their fields. I need to work on migration. Things work fine as long a...

Is there a way to specify that a model (or app, even) should only ever use one particular database? I am working with a legacy database that I don't want to change. I have two databases - the 'def...

I am trying to use multiple different DB in a single app(todo). I am using Djongo package for dealing mongodb. Settings.py DATABASES = { 'default':{}, 'sql_db': { 'ENGINE': 'django.db.backends.p...

I have monthly Data in BigQuery but I want to create a yearly database, meaning combine the 12 subdatabase to 1. How can it be done? The structure is identical for all 12 databases in form: Da...

I'm working on a django project where all my unit test cases were working perfectly. Ass soon as I introduced a second database all my test cases that inherit from TestCase are broken. At this st...

Require Spring boot application with multiple data source configured. Multiple data source configuration is working with separate datasource, entityManager and transactionManager. Also hibernate na...

I am using Django 1.3.1. I have two databases, some of my models live in one database, some in the other. Both databases are contrib.gis.db.backends.postgis databases. To my surprise, Django's Tes...

I have a django application using multiple databases. Given an instance of a model, how can I obtain the database where it is stored (if any)? I need this to save another object to the same databas...

I have an application which uses four databases in different geographical locations. All the databases contains same tables and only the database name is different according to the location. I have...

I have an application that runs Spring MVC. I need it to access 2 different databases in my app (one is a PostgreSQL and the other one is a MySQL database). How do I configure this using just ann...

I'm building a website under Django Framework, this website needs to have different SQL schemes, for now I succeeded creating all schemes and all stuff, but I don't understand why the table django_...

I have two databases that I have to use in my application. I have the following in my mongoid.yml: development: # Configure available database sessions. (required) sessions: # Defines the defau...

In here I have configured two databases in mongodb. As described in this tutorial (link). So basically I override the MongoDataAutoConfiguration and MongoProperties implementations. The property ...

I need to write a join query of two tables from two databases and fetch the joined data. For eg, consider I have a database db1 which has some tables named companies, plans, customers. Suppose I ne...

I'm building an application which requires connecting 2 database. first one is static and another one is dynamic. config/database.php is like 'mysql' => array ( 'driver' => 'mysql', ...

I'm trying to use Spring Data JPA with 2 databases in project. But an exception is triggered when I'm trying to run the application: 07:21:47.734 [main] ERROR o.s.web.context.ContextLoader - Conte...

I have an Access database containing information about people (employee profiles and related information). The front end has a single console-like interface that modifies one type of data at a time...

I'm using multiple database in my CodeIgniter application and have been reading a lot that persistent connections should be turned off. Why is this measure recommended and is this still necessary ...

I'm trying to use multiple database connection on yii2 framework. Under my db.php file inside the config folder, I have this piece of code: return [ 'class' => 'yii\db\Connection', 'component...

I'm wanting to write a "management" game that utilizes Core data heavily. The game requires a pre-set, pre-defined dataset that cannot be changed by the user/system; it is used to seed the game wit...

Ok, my first question was modified so many times that I chose to delete it and reformulate my question. I've made a small test-case project with different model-names to find a proper solution for ...

Is it valid to do something such as CREATE SYNONYM [dbo].[MyTable] FOR [AnotherDatabase].dbo.[MyTable] and then modify Entity Framework's edmx file to read this object like it would any other ta...

I am working with two MySQL Databases. I want to join a table from DB 1 with a table from DB2 in SQLAlchemy. I am using automap_base while creating data access layer in sqlalchemy as follows... c...