98 questions
-1
votes
0
answers
93
views
Calling stored procedure through task results in empty table if procedure contains cross-database join
I have a stored procedure in Snowflake that joins data from two different databases, in the following form:
CREATE OR REPLACE PROCEDURE database_1.schema_1.sp_test()
RETURNS varchar
AS
BEGIN
...
- 344
0
votes
0
answers
31
views
How to Handle Trigger-Driven Cross-Database Record Transfer with Nonexistent Users in SQL Server
I have a situation where I have a table in a SQL Server database, and this table has a trigger that, upon a user deleting a record, transfers that record to another database on the same server. ...
-2
votes
1
answer
369
views
Does WITH EXECUTE AS OWNER grant cross-database permissions?
Suppose that I have [DataBase1].[dbo].[MyStoredProc]. It modifies [DataBase1].[dbo].[HarmlessTable] and [DataBase2].[dbo].[DangerousTable]. Notice that these are not in the same database. Consider a ...
- 1,746
0
votes
1
answer
38
views
Call Proceduta Cross DB in Postgresql
I want to call procedures cross databases in PostgreSql
I found dblink, but I'm trying to understand if it's also possible to call procedures with it
If not, how can it be done?
- 355
0
votes
1
answer
289
views
Is it possible to execute a stored procedure and function with a cross-database query via php/sqlsrv?
I am working with a database that must not be modified by our code and another database on the same server set up specifically to fascilitate our needs in that regard. Some uses of the latter (let's ...
- 111
0
votes
1
answer
1k
views
Insert into Memory Optimized Table from non optimized
I have two database.
Primary have a DDL triggers so i can't create memory optimized tables there. So i created secondary database and create there table with memory optimized on. Now, in procedure on ...
- 63
0
votes
1
answer
647
views
Cannot Filter by DateTime Type in Azure SQL Cross-Database Queries
In Azure SQL Database, we use external tables to query data from another Azure SQL database. When filtering an external table by a DATETIME column, no rows are returned if the final digit of the ...
- 136
0
votes
0
answers
661
views
Alternatives to cross-database views
I have a number of tables I wish to query with an indexed view, but those tables are spread across 3 different databases, however they are all on the same server.
The documentation states that...
The ...
- 12.7k
3
votes
2
answers
8k
views
Cross Database Queries in Azure Synapse, Azure SQL Database, Azure Managed Instance and On Premise SQL Server
We are looking at options for moving our on premise SQL Server(s) to Azure and trying to understand whether we will be able to run cross database queries should we have data residing across multiple ...
- 33
0
votes
1
answer
88
views
CrossDB queries with EFCore = no / instantiating context entites as async lists = works - What is the true approach should I be taking?
I have a system with two database servers I am working with:
One of them is database first - a database managed by a legacy enterprise application and I don't have full control over changing the ...
- 363
0
votes
2
answers
482
views
Querying a SQL table and only transferring updated rows to a different database
I have a database table which constantly gets updated. I am looking to query only the changes/additions that have been made on rows with a specific attribute in a column. e.g. get the rows which have ...
- 63
0
votes
1
answer
141
views
Copying specific data from one db to another in Azure Sql Db
How can we select some data from a table in DB1 and insert into table in DB2 in Azure sql Server without using Azure Data Factory ? I have searched the internet and I found about using SSMS to ...
- 21
0
votes
1
answer
137
views
Cross Database Analytics with Azure SQL
I have in hands a few Azure SQL databases in which I want to perform analytics and visualization.
My problem is that the data I want to use for visualization is stored in different databases, in the ...
1
vote
1
answer
811
views
Reference a view from another database in Django
I have a local table which needs to reference a view from a remote database.
Both models are defined in the same app.
Now, I want to use django-import-export to import data from excel or save data ...
- 25
2
votes
1
answer
6k
views
NestJS + MySQL: how to connect to multiple databases without setting entities
The NestJS documentation about Databases explains how to connect to MySQL using TypeORM and defining Entities.
In my case, I have to connect to an MySQL server that has more than one database and I ...
- 63.2k
0
votes
0
answers
302
views
Cross-database execution of Stored Procedure
I have an application (let's call it App1) whose home Database is Home1. I have been tasked to create a Stored Procedure (let's call it SP1) in Database Home2. Using a connection in the application ...
- 371
0
votes
1
answer
550
views
connect to multiple ms access databases using odbc
When creating applications in MSAccess (VBA) you can connect to multiple databases (mdb files) by simply creating links to them. Now I have rewritten the user interface in C/C++ and using ODBC to ...
3
votes
1
answer
9k
views
Cannot resolve the collation conflict when try to find specific table and column
I use SQL Server 2016.
I need to find table name and column name across all databases on a server.
DECLARE @SQL NVARCHAR(max)
SET @SQL = STUFF((
SELECT '
UNION
SELECT ' + quotename(...
- 826
4
votes
2
answers
27k
views
Join tables from different databases (PostgreSQL)
Is it possible to join tables from different databases located in the same server, using PostgreSQL? If so, how?
- 712
5
votes
1
answer
2k
views
Building queries with a cross database join using SQLalchemy ORM and SQLite
I have two SQLite databases containing tables I need to join using SQLalchemy. For reasons I can not combine all the tables into one SQLite database. I am using SQLalchemy ORM. I have not been able to ...
- 403
0
votes
1
answer
238
views
Update a table on different database
How can I update a table on another database without giving a direct permissions on that table to the current database user?
Without using Execute As Owner because it requires Trustworthy to be on ...
- 171
0
votes
1
answer
848
views
Is FlywayDB or Liquibase used for Cross DB Migration?
I'm working on a project, which is planned to use/manage 3 different databases [MySQL, SQL Server, Oracle] as the back-end. Now I have finished with my database design and everything I have set in ...
- 1
3
votes
1
answer
2k
views
INSERT across Databases in PostgreSQL
I'm trying to do an INSERT from one database to another, eg:
//called in database 'model'
INSERT INTO login.Hospital (name, phonenumber) --EDIT, now Hospital
VALUES ('Foo Bar', '555-555-5555');
I get ...
- 313
24
votes
3
answers
46k
views
PostgreSQL copy/transfer data from one database to another
I need to copy data from one table to another. the two tables have almost the same structure, but are in different databases.
i tried
INSERT INTO db1.public.table2(
id,
name,
adress,
lat,
...
- 433
2
votes
0
answers
1k
views
Using postgres_fdw for crossdatabase queries
I have a localhost Postgres 9.3 server running with multiple database. One of those is Travelingo_data.
It has the extensions postgres_fdw and postgis installed.
What I would like to do is to run a ...
- 21