Replication of Partitioned Views in SQL Server 2005

• botlaguduru_narendra

  SSC Rookie

  Points: 45

  More actions

  September 27, 2007 at 9:50 am

  #181669

  I have a view like this

  CREATE view [hawaii_business].[POST_ID_VELOCITY]

  AS

  select * from hawaii_business.POST_ID_VELOCITY_09_23_2007

  and if I setup a replication on the Post_ID_Velocity_09_23_2007 and have the same view on the other side. It works fine.

  Now if i modify my view to

  CREATE view [hawaii_business].[POST_ID_VELOCITY]

  AS

  select * from hawaii_business.POST_ID_VELOCITY_09_23_2007 UNION ALL

  select * from hawaii_business.POST_ID_VELOCITY_09_30_2007

  AND setup replication on those 2 tables and make sure the view on the other side is same and then

  Inserts from the App fails with

  [BEA][SQLServer JDBC Driver][SQLServer]Partitioned view 'MARALPTX.hawaii_business.POST_ID_VELOCITY' is not updatable because table '[MARALPTX].[hawaii_business].[POST_ID_VELOCITY_09_30_2007]' has a DEFAULT constraint.

  Now Interestingly, If I drop the whole replication and have the view

  with 2 or 10 tables, Application works fine.

  I am new to the replication and also new to SQL Server and coming back from a ORACLE background.

  Thanks in advance for any help.

• noeld

  SSC Guru

  Points: 96590

  More actions

  September 27, 2007 at 3:32 pm

  #736937

  Make sure that the CHECK CONSTRAINTS are replicated too.

  
  * Noel