April 6, 2011 at 8:00 pm
I am using transactional replication from 2008 to 2000. The system has been running over a year without issue. This week we updated the schema on four of our tables to update data types from image to varbinary(max). Now we are replicating the 2008 database with varbinary(max) to 2000 with image. Inserts and deletes work, however updates tank. The command that is causing the issue it the usage of .write in the update statement. The error received is that the method is not valid on type image. Any and all suggests are greatly appreciated at this point. I have exhausted my knowledge and options at this point.
April 6, 2011 at 10:59 pm
i guess varbinary(max) introduced in 2005 onwards and thats what I see the problem here for existing records when you doing update.
I think while update you need to convert varbinary(max) to image datatype.
----------
Ashish
April 7, 2011 at 7:49 am
That is the somewhat frustrating part. Microsofts documentation states that is a conversion handled by replicaiton. There is an article property in the publication that allows for turning on the conversion. I have tested with the conversion on and off, still uses the .write method for updates.
May 9, 2011 at 6:41 am
sql 2000 has been out of support for some time, I'd be surprised if there were anything to deal with that sort of backward compatibility. You've already answered your own question - you're trying to replicate non compatible data types, it'll just never work! ( well it might if you rewrite the replication procs ) I too used replication from 2008 to 2000 as a fallback when we migrated - but as soon as we introduced sql 2008 features we took out the replication as it was always going to fail.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 10, 2011 at 1:00 am
Install Express Edition of SQL Server 2008 instead of SQL Server 2000 and test replication on it if problem still there then we can provide solution
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply