Questions tagged [remote]
The remote tag has no usage guidance.
9
questions
2
votes
2
answers
8k
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 ...
9
votes
2
answers
3k
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 ...
7
votes
1
answer
10k
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
2
answers
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.
...
4
votes
1
answer
7k
views
Confused by GRANT ALL PRIVILEGES ON *.* (...) WITH GRANT OPTION
Normally I manage users on my databases via phpMyAdmin, but since I do everything else in standalone programs such as SQLyog or HeidiSQL, I wanted the ability to manage users remotely from these ...
3
votes
1
answer
11k
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 ...
2
votes
2
answers
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 ...
0
votes
3
answers
797
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 ...
0
votes
1
answer
785
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 (...