In my current setup I connect to an Azure SQL Server using Authentication=Active Directory - Integrated. This method of access only allows access to a single database at a time. The architecture wa...

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, ln...

Is there any way to implement cross database querying in Entity Framework? Let's imagine I've two Entities User and Post, User entity is in database1 and Post is in database2, which means those ent...

This my model of first Database DB1: from django.db import models class Company(models.Model): name = models.CharField(max_length=100, null=True) address = models.TextField(max_length=200...

I have a web site using a database named lets say "site1". I am planning to put another site on the same server which will also use some of the tables from "site1". So should I use three differen...

I am trying to create a cross database foreign key. When I run the following code on the same database CREATE TABLE `t1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `int_id` varchar(128) COLLATE ut...

I know I've seen this solution somewhere, but I can't seem to find it now. I'm trying to query one MongoDB database while connected to another. This should be possible without explicitly connecting...

I'm importing data between two different database(which have not the same context). So I've two different context. The goal is to import some data of the context A to the context B. Data in the c...

In Postgres, you can link to your other databases using dblink, but the syntax is very verbose. For example you can do: SELECT * FROM dblink ( 'dbname=name port=1234 host=host user=user password=...

Is it possible to do cross database table joins in JPA? I have a users table in one database which has a foreign key to a organizations table in a separate database. Both the databases are on sam...

I was wondering if EF4 support cross-databse relationships? For instance: db1 Author Id Name db2 Posts Id Content db1.Author.Id What ideally I need to do to get this relation in my ef4 ...