Stack Overflow
Stack Overflow

Questions tagged [multiple-databases]

631 questions
0
votes
1 answer

insert into select query with two databases

Any body knows (insert into table1 select * from table2) query with two databases. Mean table1 is in one database and table2 is in second database,I want to insert records from table2 to table1 which have same structure but they resides on different…
Aleem Ktk
  • 1
  • 1
0
votes
1 answer

Assigning a value from another database and function - MySQL variable scope

I am using MySQL to make a report showing the number of hours billed for a particular date range and project. The complexity is that the date range is variable for each project (different start month and start day). This information is coming from a…
Daniel C
  • 607
  • 2
  • 8
  • 20
0
votes
3 answers

Cannot access table in 2nd database from MySQL query

I have 2 databases on a server: database1 database2 I am trying to query a table in each database. However, when I try that, I get the following error: Unknown table 'database2.client' in field list Here is the code that I am using in a script…
Daniel C
  • 607
  • 2
  • 8
  • 20
0
votes
3 answers

How to get data from database according to string length without using any string function

I have to get the records from a table field where Length of record/data/string is greater then 8 characters. I cannot use any string function as the query has to be used on (MySQL, MSSQL, Oracle). I don't want to do the below EXAMPLE: List…
Sardar Faisal
  • 594
  • 5
  • 20
0
votes
1 answer

SSRS showing supporting data from several other tables

I'm looking for the best approach to solve this kind of problem while reporting with SSRS Most of my data in in MainTable, but I also have two other tables which may have data, LocationList and ExtraDetails. In SQL these are connected via Id and…
rwg
  • 915
  • 9
  • 12
0
votes
1 answer

Conneting to more than two databases with codeigniter

I am working on a project which needs to connect with three databases, one in MySQL and the other two in MSSQL. I am using codeigniter as the framework and I can successfully connect to two databases. But when I try to connect to the third MSSQL…
Abin
  • 1,699
  • 1
  • 14
  • 17
0
votes
1 answer

Use and relate multiple databases

I can't seem to find a good answer to this. What is the correct way in SQLAlchemy (declarative) to connect two SQLite databases? I also need to make a relation between two tables in these two seperate databases. Edit: It is some sort of commenting…
Timo
  • 164
  • 2
  • 12
0
votes
3 answers

Class to manage MySQL and SQL Server CE databases

I have been asked to create a piece of software for internal use that will allow us to keep up to date with support requests, etc. one of the main features is the software works from a remote MySQL database, but if there is no internet connection it…
Neo
  • 2,305
  • 4
  • 36
  • 70
0
votes
1 answer

ORM tool with support for Multiple databases

I am looking for an ORM tool, which can support SQLServer/Oracle/MySql, etc. I have used entity framework earlier and not very sure if that can achieve this flexibility. But I also loved the ease and great integration in visual studio. I have also…
Numan
  • 3,918
  • 4
  • 27
  • 44
0
votes
2 answers

Rails Multiple Databases with many-to-many association

I have models with many-to-many association for example User & Role which connected through RoleAssignment table in DB1: users role_assignments table in DB2: roles I can access user in DB1 with role_one.users, but i cannot access roles in DB2 with…
raymondralibi
  • 1,933
  • 1
  • 17
  • 25
0
votes
1 answer

MVC Multiple Databases in one single domain model

I am writting an app based on Steve Sanderson's Pro Asp .Net MVC Framework, which uses a data modeling like described on Sports Store app on that book. My app works well, I use Castle project as IOC but I have two databases. The first one stores…
Bodyslicer
  • 21
  • 5
0
votes
1 answer

Search Form to search and display data from 2 database tables in a separate result page

I have a basic search form with 5 dropdown menu and I want it to search 2 database content and display it in a result page. I have not done this before and there is almost nothing to guide me on the internet. I am looking to build a result.php…
user1342542
  • 15
  • 1
  • 5
0
votes
1 answer

Django: hint for isolating data among set of users

I want to build a Django application in which each "set of users" can see different data, as they were using different DBs. Is there any best practice to achieve this? E.g. user A, after logging, sees and manages his own data, with no possibility…
Don
  • 16,928
  • 12
  • 63
  • 101
0
votes
2 answers

Magento geo-location and multiple warehouses.

This is a complex issue. So if you like to work on tough problems then this situation is for you. I'm running a Magento store that sells tires. I get tires from multiple warehouses. Some warehouses have unique tires but many of the warehouses carry…
user1325606
  • 1
-1
votes
0 answers

Can not connect postgresql database in django

I want to run jobs by connecting to 2 different databases and run them in django admin. First database is default sqlite and the other is postgresql. I want to print jobs to a table in pg, when I go to admin page the table name also looks different,…
buse
  • 1
  • 1
1 2 3
…
41
42