Stack Overflow
Stack Overflow

Questions tagged [multiple-databases]

631 questions
0
votes
0 answers

Windows Azure - Mobile services, database connection

I'm having trouble running sql commands to my database on Windows Azure. Previously I had no problems at all running my commands and stored procedures with SQL management studio until I added another database on the same server. I can still connect…
Victor Axelsson
  • 1,420
  • 1
  • 15
  • 32
0
votes
1 answer

Using multiple tables of the same database in Android

I have an application that currently works fine. It is basically an exercise application where all the user's exercise entries are kept in a table. The issue is, at the moment this application only works for one user, and I would like to make it…
theJuls
  • 6,788
  • 14
  • 73
  • 160
0
votes
0 answers

Can't query data from multiple MySQL tables

I have a bit of a problem when connecting to multiple tables, please see the code below: query("SELECT * FROM vp WHERE vp_id = 1"); foreach($vps->results() as…
Seven Stolen
  • 1
0
votes
1 answer

Copy an object to a new database in Rails ActiveRecord

I want to have a method on a class to copy the object and all of the relationships to another database that has the same structure. How can I accomplish this?
Chris McKnight
  • 8,540
  • 4
  • 29
  • 31
0
votes
1 answer

Blank Database Entry Gives Error

This is My Settings.py: DATABASES = { 'default': {}, 'company': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'leavebuddy_company', 'USER': 'leavebuddy_user2', …
Shivratna
  • 190
  • 2
  • 11
0
votes
1 answer

How to share a second Heroku DB with multiple Heroku Rails apps

I have two Heroku apps, one for staging, one for production. Each has its own separate, primary DB. I have a 2nd Heroku DB that needs to be accessed by both staging and production. Running Rails 4.1.0.rc1, when I try to use 'establish_connection'…
mdn
  • 3
  • 2
0
votes
0 answers

How to target multiple databases with Entity Framework 6 for same data?

I was wondering whether it is possible to target multiple databases with EF6. here i can see one can use two connections with two different db contexts. Configure multiple database Entity Framework 6 but i want actually to save the same information…
Jason Willfield
  • 33
  • 6
0
votes
1 answer

How to connect to multiple databases in asp.net using SqlDataReader?

How to connect to multiple databases in asp.net using SqlDataReader? Assume that I have two databases such as “Product” and “people”. The product database has two tables, let’s say table1 and table 2, while people has two tables, let’s say again…
Al-Masruri
  • 1
  • 2
0
votes
2 answers

Querying Data From Two Database On The Same Server

I'm writing a program in C# using Visual Studio 2010. I need to collect data from two tables which are in two different database. I'm using Microsoft SQL Server Management Studio to view the data. Both database are on the same server. I wrote a SQL…
sora0419
  • 2,308
  • 9
  • 39
  • 58
0
votes
2 answers

MYSQL : How to SELECT DISTINCT from multiple databases

I've got problem when i want to display my data from multiple databases. It gives duplicate values. So I have three databases in the same server. They have same table structure. So here is my query : Query = 'SELECT id_movie, movie_tittle …
Aprilia
  • 53
  • 2
  • 13
0
votes
2 answers

How to create database from the C# code in MVC 4 project

I am working on MVC 4 web app using Entitiy framework 5. I have an users membership database and an administration which divides data of the website into factories and for each factory i need a different database. Here is where my problem comes : I…
dlght
  • 1,406
  • 1
  • 18
  • 35
0
votes
1 answer

Is it a good practice to have transaction manager bean as Prototype scoped

I want to connect different databases based on User login, So I am having the TransactionManager bean as Prototype scope and it is creating transacionManager bean everytime, and works well. But , Is it good when the scope of the application…
Mohamed Niyas
  • 1
  • 1
0
votes
1 answer

Multiple Raven Databases with different Replication strategies

Raven DB creating multiple Databases to support different replication strategies. Recently I was tasked with creating an additional raven database to store information pertaining to users. So the solution I working on would have some information in…
micvp007
  • 1
0
votes
1 answer

SO uses single or multiple databases?

I want to build a web application like StackOverflow, and I don't know SO use single or multiple databases. SO has 2 main applications: Asking application and Chat application Chat application uses SO account to login and display user's information…
Jack Cood
  • 301
  • 3
  • 10
0
votes
3 answers

Add columns in multiple databases

I need to add 3 new columns to a table named Requirements in all the databases (of same instance). I searched in net to find sp_MSforeachdb can be used to execute same query on multiple databases, but could not find any example with a alter…
Ram Grandhi
  • 397
  • 10
  • 27
1 2 3
…
41 42