Stack Overflow
Stack Overflow

Questions tagged [multiple-databases]

631 questions
0
votes
1 answer

Server principal "User" unable to access db "Metals" under the current security context

I am attempting to create a query that accesses multiple databases on a single server. I am using a cursor to access multiple other linked servers to the base server that the query is run on. The issue that I am running into is the following: Msg…
DiggityCS
  • 111
  • 7
0
votes
3 answers

retrieving data from two databases

I have two databases and tables in each. Am reading the renewal_date of DB1 table 1 and taking the renewal_date of the current month and domain_name for that record. then am trying to retrieve the d_due_date from DB2 table2 for the domain_name…
user3358839
  • 147
  • 1
  • 1
  • 7
0
votes
5 answers

good way to query many databases in ASP.NET

What I'm trying to do is run the same SQL select on many Oracle databases (at least a dozen), and display the output in a Gridview. I've hacked together something that works but unfortunately it's very slow. I think its exacerbated by the fact that…
Colin Pickard
  • 45,724
  • 13
  • 98
  • 148
0
votes
1 answer

ZF2 How to get unloaded config file in controller?

The cenario My application is divided by many agencies, each one with it's own database and database configuration file. Before logging in, the user needs to send me an agency-id. In that request ZF2 load a non-agency db configutarion file (with…
Edson Horacio Junior
  • 3,033
  • 2
  • 29
  • 50
0
votes
1 answer

Two tables with similar columns but different primary keys

I have two tables from two different databases, and both contain lastName and firstName columns. I need to create JOINa relationship between the two. The lastName columns match about 80% of the time, while the firstName columns match only about 20%…
KiloVoltaire
  • 265
  • 3
  • 10
0
votes
0 answers

SQL Multiple Database Table Query for Value

I'm trying to craft a straight SQL (not stored procedure) query that finds all databases in a MySQL database server with a table whose name matches a pattern and has a certain collation, and then use the list of those database names and table names…
Chris
  • 1,881
  • 3
  • 20
  • 27
0
votes
1 answer

Different databases per user account after login in CakePHP

I want to create separate databases for different registrations. First i was doing it via multiple sub-domain manually but now i want it to be automatic after registration when anyone sign up. This is what am thinking to implement: First i'll…
Anupal
  • 1,502
  • 2
  • 11
  • 15
0
votes
1 answer

Crystal Reports Joining Tables from Different Databases

I'm trying to pull data into a crystal report from two different databases. My understanding is that its possible to pull data from two identical tables using a UNION query, however my tables aren't the same. They need to be joined on a particular…
Jonathan3524
  • 1
  • 1
  • 2
0
votes
1 answer

SSIS Lookup multiple identical databases

I'm working on a project where i need to do lookups on a data warehouse server in Integration Services. My problem is that I need to be able to change what database it i performs the lookup to. The databases are design wise identical. I have solved…
August
  • 3
  • 1
0
votes
1 answer

How can I develop an application which will run on more than one database at a same time using Spring + Hibernate?

I am developing a Java application using Spring + Hibernate. i want this application to run on more then one Database on same time. For Example if user tries to search for some data, Application has to search for that data in all the configured…
Kushal
  • 71
  • 8
0
votes
0 answers

Entity Framework with changable database

Our clients have tools to change database schema..add columns change column type etc... There is a way to use EF in that scenario? I know about code first approach and that if I add column to a table in the .edmx schema I can run update data base…
Israel Rozen
  • 1
  • 1
0
votes
1 answer

integrate databases of different rows by multiple conditions in r

I tried merge and a all series of for/if loops of which the best I will report. I read several posts but I could not find any that does quite match. I have 2 databases, one of 360 rows and the other one of 60 rows. I would like to add some columns…
have fun
  • 381
  • 5
  • 17
0
votes
1 answer

Multiple databases in Rails

I'm trying to setup two database for a single Rails Application. The first one is would be the main database and the second would be there in the case the main database would crash. So, I need to manage the two databases (rake db:create, migrate...)…
Aeradriel
  • 1,224
  • 14
  • 36
0
votes
2 answers

SQLAlchemy - Multiple Database Issues

We are making a game server using SQLAlchemy. because game servers must be very fast, we have decided to separate databases depending on user ID(integer). so for example I did it successfully like the following. from threading import Thread from…
Anderson
  • 3,139
  • 3
  • 33
  • 45
0
votes
4 answers

Looking for a good implementation that will access multiple databases simultaneously

I just want to find out if there's a good implementation (in C#/ASP.NET) on how to access my records from my different databases simultaneously. I have this simple application which suppose to search on these databases, then, display the record if a…
abramlimpin
  • 5,027
  • 11
  • 58
  • 97
1 2 3
…
41 42