2

If I have a Sql server AlwaysOn Availability Group, can I do a transactional push replication to it?

Mathias Rönnlund
  • 4,078
  • 7
  • 43
  • 96

2 Answers2

4

Yes, it can be. Check out THIS under the restrictions of alwayson and replication.

  • Did I read it correctly, that the replication is not automatically transfered to the secondary replica when the primary sql server goes down? Additionally, can the publisher/distributor be sql server 2008 r2? – Mathias Rönnlund Feb 09 '15 at 06:44
  • it will be automatically transferred for push subscription b/c it is taking to your listener defined as linked server. – grillazz Feb 09 '15 at 09:00
  • Are there any restrictions on the sql server version of the publisher? – Mathias Rönnlund Feb 12 '15 at 10:18
  • The publisher can't be newer than the distributor and subscriber. –  Feb 12 '15 at 15:42
0

you can't configure subscriber using management studio

-- commands to execute at the publisher, in the publisher database:  
   use [<publisher database name>]  
   EXEC sp_addsubscription @publication = N'<publication name>',   
   @subscriber = N'<availability group listener name>',   
   @destination_db = N'<subscriber database name>',   
   @subscription_type = N'Push',   
   @sync_type = N'automatic', @article = N'all', @update_mode = N'read        only', @subscriber_type = 0;

GO 

   EXEC sp_addpushsubscription_agent @publication = N'<publication     name>',   
   @subscriber = N'<availability group listener name>',   
   @subscriber_db = N'<subscriber database name>',   
   @job_login = null, @job_password = null, @subscriber_security_mode = 1;

GO 

  and push subscription better for alwayson with replication subscriber.
Gulrez Khan
  • 101
  • 1