All Questions

Filter by
Sorted by
Tagged with
0
votes
2answers
29 views

Azure Database Link to another Azure database

How to query between two databases with the same server in SQL Database? Currently we are aiming to link two azure databases that will update simultaneously. Thanks!
1
vote
1answer
37 views

FILEPROPERTY not working over linked server to Azure SQL Database

FILEPROPERTY (Transact-SQL) is not working with a linked server pointing from a on-Premise SQL 2017 to a Azure SQL Database. I see the following comment in books online: Returns NULL for files that ...
-1
votes
1answer
780 views

Oracle Linked Server in Azure SQL Database Managed Instance

I am migrating my On Premise SQL Server to Azure SQL Database Managed Instance. But I have linked server to Oracle database in my SQL Server. Can we create linked server to an On Premise Oracle ...
0
votes
1answer
849 views

Replication/Mirroring/etc from Azure SQL Database to On-premise SQL Server possible?

I have a table on Azure SQL Database that I would like to have replicated/mirrored to our on-premise SQL Server So the on-prem SQL Server would have a copy of table from Azure that is always up-to-...
1
vote
2answers
299 views

Azure SQL Db Linked Server - Secured Connection Methods?

The developers want a linked server from our on-prem server to our Azure SQL Db (DBaaS) in order to complete a nightly data pull into our data warehouse. I'd much rather go the route of SSIS but don'...
0
votes
2answers
2k views

Joining table from Linked Server is very slow

I have a production SQL server and a linked server (Azure SQL Database) I join two tables to do update Table A - small table A in TempDB that has only 100 rows on SQL Server Table B - on linked ...
5
votes
2answers
1k views

Linked Server to Azure Error: “Access to the remote server is denied because no login-mapping exists.”

I'm setting up a linked server from an on-prem SQL Server to a database on MS Azure (see below). When non-admin users query the Azure database via the linked server they get: Msg 7416, Level 16, ...
1
vote
1answer
639 views

Unable to connect on premise sql server from Sql Azure db [closed]

I have two SQL Server databases: On-Premise : See the image below. We have a static IP associated with this server in order to access remotely from other development machines. Machine is deployed in ...
3
votes
2answers
3k views

Linked Server alternative in Sql Azure database

We are migrating database from Rackspace to Azure. Our databases were deployed on Virtual Machines in rackspace. In our queries we are using Linked server to other databases. Basically cross database ...
4
votes
1answer
5k views

Insert to SQL Azure through Linked Server very slow

I have a table on SQL Asure server with no indexes except clustered. And I insert into this table small amount of data just about 1000 rows and it takes more than 4 minutes. Although, when I do it ...