Stack Overflow
Stack Overflow

Questions tagged [multiple-databases]

631 questions
0
votes
1 answer

How can I set default database in Rails?

I have an application that use two databases. Now I have in development environment. How can I set the databases for each environment by default in Rails? My database.yml looks like: database1_dev: adapter: mysql2 host: localhost database:…
Cristhian Boujon
  • 4,060
  • 13
  • 51
  • 90
0
votes
1 answer

ContentProvider Sqlite and many users. Should I create individual db`s for users or how to control that

As the title say. I have search for a solution but I thing i'm on the wrong path with this. I feels like the easiest way would be to setup a new db when the app recognizes user change. Max 2-3 users. The flow of the ContentProvider will be the same…
Erik
  • 5,039
  • 10
  • 63
  • 119
0
votes
1 answer

how to select data from two tables of different databases using dblinks in oracle?

i have a table t1 in database A and another table t2 in another database B. how can we select data from them without using qualifiers directly.. just as database1.table1.something.
isaiahbabu
  • 1
  • 1
  • 1
0
votes
3 answers

How to override Capistrano's deploy:migrate

Our rails app (3.2.12) has two databases, a content database and an user database. How can I override deploy:migrate (rakefile here) so that during a "cap production deploy:cold" migrations are correspondingly run for their both the target…
paddle42380
  • 6,921
  • 7
  • 32
  • 40
0
votes
1 answer

Closing/Reopening iPhone app on different page

I am an elementary school teacher currently working with a developer through Elance on a reading log app for iPhone/iPod/iPad. The app allows for multiple users to create individual profiles/reading logs. Users will then access their logs via a…
bradfdlad
  • 29
  • 1
  • 1
  • 11
0
votes
1 answer

SQL Server Returns a "Query Executed With Errors" and doesn't finish executing though told

I'm no expert in SQL Server and this question may be a little convoluted, but I have to try something! I'm running through each database on a server in order to gather some stats. In development of the correct SQL code, I was using a relatively…
user1261648
  • 25
  • 9
0
votes
1 answer

Select from multiple SQL Server 2008 databases not working

I'm trying to select from a few tables in different servers using SQL Server 2008. This is the script I'm using: exec sp_addlinkedserver @server = '192.168.5.208' select * from [192.168.5.208].[hrm2].[dbo].tb_mt_pim but it doesn't work. It returns…
dapidmini
  • 1,490
  • 2
  • 23
  • 46
0
votes
2 answers

Combining results from 2 databases in codeigniter

I'm trying to work out how to combine the results from the same table in 2 mysql databases using codeigniter. Both tables have the same column names, but the databases have different connection settings. I'm currently trying this: public function…
Nick W
  • 3
  • 1
  • 5
0
votes
1 answer

Multiple Database drivers in NHibernate

I am new to NHibernate and was thinking to use it in a project which could support different database like (Oracle, MySQL, SQl Server, DB2 etc..) as this product might be shipped to different clients who could use different datbases as per their…
Sarvesh
  • 269
  • 1
  • 2
  • 10
0
votes
0 answers

MySQL Multiple Databases for User Authentication

I have a few related web sites and it seems rather unfortunate that they have completely separate user databases. I've been contemplating different options on how to unify the databases: Rework the sites to be running on one copy of my content…
Timothy R. Butler
  • 1,097
  • 7
  • 20
0
votes
1 answer

Comparing multiple csv files and finding matches

I have two folders with csv files. A group of 'master' files and a group of 'unmatched' files. Within the master files (~25 files, about 50,000 lines in total), there are unique ids. Each row of the unmatched files (~250 files, about 700,000…
jack
  • 9
  • 2
0
votes
2 answers

CodeIgniter Datalink with both MySQL and MSSQL

I know there are several questions that is similar to this question, but somehow I am not able to get it to work, and I have been going around to check for solution but unfortunately I cant find any: Situation: I have a web application built in…
rfpdl
  • 956
  • 1
  • 11
  • 35
0
votes
0 answers

What is the best way to connect multiple database using PDO class?

I am creating one database wrapper class and want to have a feature to connect with multiple database using PDO. I have connected multiple database using pdo as below. $config = array( 'database1' => array( …
appsntech
  • 722
  • 1
  • 6
  • 21
0
votes
2 answers

Fetching data from multiple databases with MySQLi

i'am using MySQLi to connect and fetch data from my MySQL server with $link = new mysqli("localhost", "root", "","database_1"); I have a file that used for connection and data collection (dboperations.php) from above database Now , i need to connect…
Alper
  • 1,085
  • 3
  • 20
  • 39
0
votes
1 answer

Yii - delete or save to multiple databases using CActiveRecord

I want my model to do some action into multiple databases. Let's say my model is User class. It extends SynchroAR class (SynchroAR extends CActiveRecord). In User Class: protected function afterSave() { if($this->goSynchro) …
Joe
  • 2,551
  • 6
  • 38
  • 60
1 2 3
…
41 42