Questions tagged [multiple-databases]
631 questions
-1
votes
1 answer
Multiple SQL joins on 2 different databases with multiple tables
I'm attempting to create the correct set of joins on multiple tables across two different databases but i keep running into syntax errors ("Incorrect syntax near the keyword 'join') whenever i run the following query. What's causing this and how can…
-1
votes
1 answer
How to use multiple datasets from different measurements for one prediction with machine learning models? How to split data into Train Test sets?
I'm working on Capacity prediction models for Lithium-Ion batteries.
I have 10 datasets from 10 different batteries including the capacity and multiple features. Each dataset is time dependent. In the end I want to predict the capacity for a…
steffi44
- 1
-1
votes
2 answers
Multiple database connections with Yii 2.0
I have a system based a pure PHP and now I try to convert the codes into Yii2.
but I have a problem in this steps, I have a database for each user its mean when user register in my system, I will create a new db for it, and also there is a main…
Mahmood
- 1
-1
votes
1 answer
Duplicate value from multiple database
I want to make a list of all duplicate values for column ID from 4 databases in the same table A.
For Instance
DB1 has TableA and Column ID
DB2 has TableA and Column ID
DB3 has TableA and Column ID
DB4 has TableA and Column ID
and I want to find…
Duffer
- 256
- 1
- 14
-1
votes
1 answer
Running two databases on heroku with django
I have two databases that my Django application needs access. One is a shared database owned by a separate app with the Django app only having read access. The second is entirely owned by the Django app.
For local development I am ok but I'm not…
wuliwong
- 4,238
- 9
- 41
- 69
-1
votes
1 answer
FlyWay not picking up JVM memory settings
I am using Flyway to deploy to 300!!! Databases. What I've done is created a cmd file that has the flyway command - 1 line each for each of the 300 databases.
Like this:
flyway -configFile= -url= migrate.
There are 300 such lines in the cmd file and…
Mihir
- 11
- 5
-1
votes
1 answer
how are realtime database systems different from timeseries databases
I understand time series databases like influxDB etc... are used to store metrics or variables that change over time. eg uses would be to store sensor data or metrics like counters and timers.
How different is it from a realtime database since…
Tapan Nallan
- 1,762
- 3
- 17
- 37
-1
votes
1 answer
working with two db connections in spring boot
I want to work with two databases in Spring Boot, - some models go to db1, others to db2
But how can i swap between them, or tell which repo belongs to which db?
#…
Anders Pedersen
- 2,255
- 4
- 25
- 49
-1
votes
1 answer
How to creating wordpress blog with two databases
I have three blogs, blog A,blog B, blog C.Blog A contains its related data, blog B contains its related data but blog C contains both blog A and blog B data,
now i want to combined blog A and blog B into blog C.
I have tried using Hyperdb and…
Naisa purushotham
- 905
- 10
- 18
-1
votes
1 answer
Targeting multiple DBMS using ORMs in the same application
My question is not if that possible but the level of configuration required to do that.
To be more clear, I want to connect to two databases that have the same schema but under two different DBMS (Oracle and SqlServer). I want to use in the same…
Benzara Tahar
- 2,058
- 1
- 17
- 21
-1
votes
1 answer
INSERT into table including foreign keys to related tables
Please if someone could help,
I have three tables: 1. Clients; 2 Accounts; 3. Transactions ...
I want to get ClientID by ClientName and also AccountID by AccountName and then insert those ID`s to Transactions and some other values for some other…
Pito Axiu
- 1
- 4
-2
votes
2 answers
entity framework code first multiple databases
i have been developing my application with code first and i havent had any problem since i decided to use second database for my generated forms;
so i created a new context called FormContext and specified the connection string name in contractor(i…
Navid Kianfar
- 29
- 1
- 5
-2
votes
1 answer
ASP.NET Web Application with multiple database support
We are developing a asp.net web based application, so for example if I want to deploy the same web application with MS access as back end or Sql as back end, the data access layer it should use should be configurable.
If I go with the below…
Arun
- 42
- 1
- 8
-3
votes
1 answer
In django, can the .using('db') keyword take a variable?
Example.objects.using('db').raw()
Instead of db could we have a variable that would correspond to the appropriate database?
mparoufakis
- 3
- 1
-4
votes
1 answer
Develop a program in Stata to handle multiple files in work folder just like SAS using tempfile
I am developing this wrapper around tempfile in Stata to handle multiple datasets at the same time without having to save them in current directory. So in essence I want Stata to mimic SAS, and that is the reason the program name is work; the…
Sartaj Raja
- 1
- 1