Questions tagged [remote]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
Shashank's user avatar
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 ...
odinho - Velmont's user avatar
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 ...
Guillermo Gutiérrez's user avatar
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. ...
jila's user avatar
  • 53
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 ...
zx81's user avatar
  • 143
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 ...
Gabriel R.'s user avatar
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 ...
Johnathon64's user avatar
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 ...
Uğur Gümüşhan's user avatar
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 (...
Lori's user avatar
  • 121