Tagged Questions

I'm trying to think through a setup with a central mariaDB instance (A) accessing data on physically remote servers (B).
All queries to the database (A) can be answered from indices only. Indices are ...

I have developed one application in vb6, and i am using online MySQL database server for storing my application's data. So when i am try to connect with my database server,when first time i connect to ...

I have successfully gotten pgAdmin on my development machine to do ssh tunneling over the internet to my production server. I can see the remote database and browse its tables and such.
➥ How to suck ...

We have a SQL Server SQL and a web server WEB.
In SQL, we have a SQL user named test with password test with correct permissions set up.
If we run SSMS on SQL and login locally with the test user it ...

We connect to our customer's database server with vpn. Sometimes we manage Sql server to connect database server or to connect with ssms in our pc's.
I executed a query with ssms in database server, ...

I have a fresh install of mysql server 5.2.6 on a 64 bit Ubuntu running on a remote server with static IP. Is there anyway to allow Mysql remote connections to be made from pre-approved IPs only?
I ...

I would like to know if it's possible to restore a database from a remote sql file.
The problem:
- Working with PostgreSQL 9.2.4
- I have an small remote server with 10GB left in storage
- I have a ...

I'm issuing a DROP TABLE command that is taking a very long time. If I close down my local MySQL Workbench, will the command still be running and finish on the remote server?
If it doesn't, is there ...

I just went through the obligatory pain of getting MySQL to accept a remote login. Yes, I had to create a user of the form ''@'%', and I did so. Yes, I had to GRANT ALL ON . to my new '@%' user and ...

I have a remote Postgres server recording some data every second. the server has very less space like 6-7 GB, currently I write data to a remote VM server but due to poor connectivity the applications ...

I am running Postgres 9.1 on Ubuntu.
I have host all all my.ip.address/32 md5
set in pg_hba.conf and listen_addresses= '*' set in postgresql.conf.
Running show listen_addresses shows '*'
Running sudo ...

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

I've seen on DBA and other sites that exposing a database to the Internet is a particularly bad idea, but I noticed that PostgreSQL has SSL-certificate-only authentication. Does this make it any safer ...

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

I have installed sql server 2012 Express on a local network machine, then added a new login: "sqlUser" mapped to "database1", and configured the instance to accept the remote access with both Windows ...

We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...

I would like to launch the command: pg_dump.exe -h 255.255.255.255 -p 5432 -U postgres -F p -a -v -f "test.db.dump" mydb from a remote computer. Both the database and the remote computer are under xp.
...

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

I'm working with MSSQL Server Management Studio 2008 and I need to expose a view to a third party for their data reconciliation. I have created the appropriate view but I'm having trouble creating a ...

Hell all
I am new to windows server 2008 and we are trying to transfer our website from hosting to virtual server.
I installed SQL Server 2008 Express edition and I did the things like opening port ...

I am attempting to find a reliable service that does remote MySQL Database Backup.
Price is no object, unless it's absurdly expensive. I understand this question doesn't really have an answer, and I ...