All Questions

Filter by
Sorted by
Tagged with
1
vote
0answers
27 views

Syncing On Prem SQL Server with Azure SQL

We have a SQL 2016 instance running production systems at a pretty healthy load within AWS. On top of this we host instances of production databases in Azure for PowerBI and analysis usage. At ...
1
vote
1answer
29 views

Transactional replication of Date column from Sql Server 2012 SP4 to Azure Sql Database

We have a Sql Server 2012 SP4 where we are trying to setup transactional replication to Azure Sql Database. When starting replication is says Column mycolumn in object mytable contains type Date, ...
2
votes
0answers
59 views

Does Azure SQL natively support being the subscriber in transactional replication where Oracle is the publisher?…and if PostgreSQL is the publisher?

Is there a native way to setup transactional replication where an Azure SQL database is the subscriber and the publisher database is in Oracle? What if the publisher database is in PostgreSQL? If ...
1
vote
0answers
46 views

Where can I find the failover history for an Azure SQL Database with geo replication?

We have an Azure SQL Database that is geo replicated to another region. I suspect that they have swapped which is primary and which is secondary and would like to find information about when that has ...
1
vote
0answers
59 views

Spin up an extra sql azure instance to reorganize/rebuild indexes with no downtime

We have a pretty large sql azure database, over 300GB. Many tables have been altered over time and we would like to create fresh indexes, including clustered ones. Of course we would like to minimize ...
1
vote
1answer
58 views

Is it possible to set up Azure as a publisher for Pull Replication to an on-premise database?

I am trying to set up Pull Replication from an Azure database to an on-premise database. I have set up the on-premise database as the distributor but when I try to establish a subscription to the ...
1
vote
1answer
121 views

AWS VS Azure , which one is preferable for SQL Server 2012 standard version? [closed]

I want few recommendations while considering azure vs aws for our current database which is SQL Server 2012 standard edition. Currently we are using AWS RDS for managing our database, recently we had ...
0
votes
1answer
853 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-...
0
votes
1answer
2k views

Transaction replication from SQL Azure database to on-premise SQL server

I have a use case where I need to keep an on-premise SQL Server database in-sync with my Azure SQL database. Is there a way I can set up replication / sync from the Azure SQL db to the on-prem db?
1
vote
1answer
628 views

Replicating on-premise SQL Server instance with hundreds of databases to an Azure SQL Managed Instance

I am wanting to replicate an entire SQL Server 2016 on-premise instance of databases (300+) to an Azure SQL Managed Instance for redundancy of a read-replica in case of on-premise downtime. It appears ...
1
vote
1answer
678 views

How can I synchronise Always Encrypted data from On-Premises to Azure SQL Database (near real time)?

Let's say I have On Premises SQL Server 2016 SP1 and Azure SQL Database. There is no way at this point to redirect whole solution directly to Azure SQL Database and I need to have a copy of the ...
4
votes
2answers
538 views

Is there any way to detect and get information on a push-subscription on subscriber's side?

I've got a database in Azure SQL. There may be a push-subscription from on-premises database. I have no access to on-premises servers where distribution/publication/subscription is created and ...
1
vote
2answers
1k views

Syncing data between onprem and Azure SQL

I have the following Scenario: an on-premise SQL Server 2008 R2 and an app using it as db. I want to create an Azure SQL database that will be synced (asynchronous replication) with the on-premise ...
2
votes
2answers
3k views

Replication Access denied in Replication

I have a database on-prem, and I have an Azure account. I need to establish transactional replication from the on-prem to Azure. First of all I created a publication and after that I made a ...
0
votes
1answer
369 views

What are options for Bi-Directional Replication of SQL Azure Database

This questions came from a developer friend who is working with SQL Azure Database. Scenario: There are two Azure DB servers, one in North America, USA region and another one in South East Asia ...
1
vote
1answer
28 views

Transactional Replication guidance

As a real newcomer to Transactional Replication I would appreciate some guidance. I have a production database on premise and the need to take two tables from here and copy them regularly to a SQL ...
2
votes
1answer
4k views

Transactional Replication from SQL Server to Azure SQL

I'm attempting to setup transactional replication between an on-premises SQL Server and an Azure SQL database. Unfortunately, it looks like Azure SQL doesn't support SQL Server Replication, and Azure ...
2
votes
1answer
4k views

Continuous replication between Oracle Database and Azure SQL Database

Background info: Our core ERP has its data on Oracle. Our own applications are Microsoft SQL Server based. Almost every application reads data from this Oracle database and usually there is some sort ...
1
vote
0answers
350 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
4
votes
2answers
1k views

Replication between SQL Server 2005 and Azure database

Is it possible to set up transitional replication between a SQL Server 2005 and a SQL Azure database? My server is nearing end of life and I would rather migrate to a cloud infrastructure instead of ...