Tagged Questions
5
votes
3answers
172 views
What type of SQL Server Replication fits our scenario? Merge or Transactional?
Background
In our current setup, we have a single SQL Server 2005 instance on our remotely hosted web server. We additionally have another (non-MSSQL) database which we use for our POS system, which ...
3
votes
1answer
80 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 ...
4
votes
1answer
331 views
How to restore replication after server crash
We had two databases on one SQL Server 2005 instance with transactional replication between them (3 tables as articles). This server acted both as publisher and distributor.
Then the RAID on the ...
1
vote
1answer
127 views
transactional Replication of millions of updates
I have standard transactional replication setup from 2005 to 4 2008 subscribers. One of the tables that is replicated is updated several times from an agent job resulting in 6 million updates ...
