Replication question sql 2008

• chandan_jha18

  SSChampion

  Points: 11330

  More actions

  June 27, 2011 at 11:01 am

  #252588

  Dear all,

  I have a database of sql 2008 version in the compatibility mode of 90(2005) .It has a table which has two columns of the data type 'date' which is new in SQL 2008. Now when configuring the transactional replication to a subcriber on 2008, it fails during the snapshot step saying that 'date' is not valid data dtype in sql 2005.

  I believe that due to lower compatiblity mode of the publisher, the script that gets generated from it during snapshot, generates it thinking that it is generating it for a 2005 database and then it fails because the 2005 does not understand 'date' . I have an option to change the compatibility mode of publisher but it is risky and needs some good time to analyze the database.

  Is there a way for me to tell the sql server to generate the snapshot for a true 2008 database.

  Thanks

  Chandan

• john_jakob

  Mr or Mrs. 500

  Points: 587

  More actions

  June 27, 2011 at 1:40 pm

  #1344778

  Don't have an exact answer -- but here's something to try.

  Make a copy of your database on the publisher, and set the compatibility mode on

  the copy to normal SQL 2008 (100) compatibility.

  Then using the DB copy, set up the replication like you did before, and look at the scripts

  that are generated. See what difference(s) if any exist in the scripts.