All Questions

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
60 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
29 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
0answers
52 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
61 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
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 ...
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 ...
0
votes
0answers
21 views

What happens to the transactional replication if azure sql Vm(publisher and distributor) is stopped and restarted from portal?

I am a newbie...I have azure sql vm and sql managed instance. I have setup transactional replication between them. Now if I stop the vm from the portal will the replication still continue after ...