Stack Overflow
Stack Overflow

Questions tagged [multiple-databases]

631 questions
0
votes
1 answer

Using Multiple databases with a common code

I just want to be able to store and access data from ACCESS,SQLSERVER,SQLCE,SQLLITE based on the users choice. Is there a SINGLE library that can help me do this job in c#? I would like to simply change the connection string and not the code. Is…
Josh
  • 13,530
  • 29
  • 114
  • 159
0
votes
2 answers

MongoDB as main datastore, MySQL for transactions only

I'm having difficulty finding good sources of information on how to solve this problem. Most search results, both here on SO and outside, come up MongoDB versus MySQL rather than MongoDB with MySQL. Database design isn't really my strongest forte --…
Zero
  • 717
  • 6
  • 21
0
votes
2 answers

Rails database relationships

I have three models that I want to interact with each other. Kase, Person and and Company. I have (I think) setup the relationships correctly: class Kase < ActiveRecord::Base #HAS ONE COMPANY has_one :company #HAS MANY PERSONS has_many…
dannymcc
  • 3,744
  • 12
  • 52
  • 85
0
votes
1 answer

Validating session variable at the model Repository MVC 4 code first

I have multiple databases linked to the same db context and I pass the connection string which is saved in a session variable to the db context. In order to make the application more robust, I would like to validate whether the session variable is…
ecasper
  • 489
  • 1
  • 10
  • 30
0
votes
1 answer

Wordpress: Use wp_insert_post() in CronJob on Multiple installations

I try to insert programmaticly wordpress posts via cron job. I have set up many DB Connections $DB = array( 'naruto' => new wpdb('ultimate_naruto','','ultimate_naruto','localhost'), '4k' => new…
Sven Delueg
  • 1,001
  • 11
  • 23
0
votes
1 answer

Combine data across dozens of DB's in a non-expensive query?

I run a site where companies create accounts and have their users sign up for their accounts. A couple of the companies I work with have sensitive data and for that reason the decision was made a while back that we would maintain separate databases…
What have you tried
  • 11,018
  • 4
  • 31
  • 45
0
votes
1 answer

How to access content in another database from PHPMyAdmin

I have two databases, one that is for my web-app and the other is for my android app. I wish to occasionally allow the Android app to query and insert into the table in the database for the web-app, but do not know how to do so. Is it simply an SQL…
Sauron
  • 6,399
  • 14
  • 71
  • 136
0
votes
2 answers

Switch dynamic database from other DB in Codeigniter

mi file config.php is: $active_group = 'default'; $active_record = TRUE; db master is unique DB $db['master']['hostname'] = "localhost"; $db['master']['username'] = "root"; $db['master']['password'] = ""; $db['master']['database'] =…
user3445492
  • 71
  • 1
  • 1
  • 5
0
votes
1 answer

What table data should persist when migrating Orchard CMS data into multiple environments?

With Orchard CMS 1.6, I have four environments set up: Development, Testing, Staging, and Production. I have made a lot of changes from the Orchard UI Dashboard in Development and I want to migrate those changes into other environments. A related…
David Vogel
  • 465
  • 8
  • 23
0
votes
1 answer

updating Stored Procedure for multiple database

I have 80 different databases to maintain and all the databases has the same tables and stored procedures but the information stored is different, the way it works is that we have created a separate database for each client, and each client will…
Prashanth Kumar B
  • 566
  • 10
  • 25
0
votes
1 answer

Connecting and importing models from multiple database connections Django

In a django app, I have two postgresql databases connected through settings.py: one is default and other is AppDb. AppDb is placed on a remote machine. I want to query from a 'Courses' model from AppDb using 'using()' and 'Courses' model is not…
escapee
  • 413
  • 1
  • 6
  • 14
0
votes
1 answer

OpenERP DB Connectivity with Django

Is it possible to have direct connectivity of OpenERP DB with Django ? I am able to connect openerp with xmlrpc, but there few custom module tables which I want to modified directly. I am not sure what is right and correct way to direct sql statment…
user2447747
  • 1
  • 4
0
votes
2 answers

Entity Framework Code First - Relationship between multiple databases

I would like to know if it is possible to map relationship between two different databases using Code First. For example i want to deploy different websites with the same database structure(same system). But i want one Master Database to have tables…
user3753000
  • 3
  • 3
0
votes
0 answers

SOLR merge fields from multiple data sources

I have two databases which contains different attributes about a person. Database 'A' may contain fields like age, location. Database 'B' may contain fields like occupation, education. Database 'A' users Database 'B'…
blue01
  • 2,035
  • 2
  • 23
  • 38
0
votes
0 answers

Spring with multiple persistence units defined in persistence.xml

I am trying to have multiple persistence units with different databases in a Spring application, but without success so far. I have tried different scenarios, but no one has helped, so I will post some initial code that I think should…
V G
  • 18,822
  • 6
  • 51
  • 89
1 2 3
…
41 42