Questions tagged [remote]
The remote tag has no usage guidance.
8
questions
2
votes
1answer
7k views
Connecting remote MySQL database to local MySQL database?
I want to write PHP code to be embedded in a Drupal7 module.
I want to call a procedure which can copy newly generated data in the local MySQL database to a remote MySQL database.
When data is ...
8
votes
2answers
2k views
Foreign Key (references) constraint on PostgreSQL Foreign Data Wrapper?
It seems to be disallowed to add a Foreign Key constraint to a foreign table. Is there any other way to do this? My two tables have these constrains on the remote server.
More specific details:
I ...
0
votes
3answers
759 views
Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote ...
7
votes
1answer
9k views
How to insert in table from remote stored procedure without creating a distributed transaction?
How can I insert in a local table from a remote stored procedure without creating a distributed transaction? I want to run a stored procedure on a remote server and use the output as the source for an ...
5
votes
2answers
3k views
Federated tables and triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fetch" rows from another table (T1) on DB1.
...
2
votes
2answers
5k views
Cannot remotely connect to SQL Server 2012 VM on Azure
I have a SQL Server 2012 instance running on a virtual machine in Azure. I have tried to connect to it using the public virtual IP address; however, I get an error saying:
The server was not found ...
3
votes
1answer
10k views
DB2 Defining remote database alias
I'm using DB2 9.7.0.3 for AIX.
I want to select data from a remote database, also running DB2 9.7.0.3 for AIX, and insert it into the local database I'm connected to.
I believe the query for this ...
0
votes
1answer
652 views
Split data across databases/machines
I have two questions about how to partition data across servers.
Can I create and connect two or more databases, with the records correctly associated, using only a mapping table stored in a third (...