April 28, 2009 at 6:12 pm
I have a database that I have been told to upgrade from 2000 to 2008. I am all for this as this is one of the last 2000 databases left. But this database is replicated to a 2005 database that I do not control.
Is it possible to set up transactional replication between a 2008 instance and a 2005 instance?
I have been reading through techNet articles and I am under the impression that it is. But I have not seen anything written up showing how. My concern is that I when I have been playing around with the wizard I see the message "The publication compatibility level will support Subscribers that are servers running SQL Server 2008 or later." And I can not find anything on how to change this to support subscribers running sql server 2000 or 2005.
April 28, 2009 at 7:29 pm
so after a bit more digging it looks like I am able to replicate most of what I need. But UDT's are so far still causing me issues. At this point I am only able to test 2008 to 2000 and am hopeful that this will not be as much of an issue with 2005 since the mapping of data types for UDT's work better with 2005. It appears that I need to map these to other data types though I am still not entirely sure how to specify the mappings.
April 29, 2009 at 12:55 pm
Worked much better with 2005, no issues at all with converting data types.
And finally found the setting that I had missed for getting it to work with SQL 2000. Needed to set "Convert MAX data types to NTEXT and IMAGE" = True. Even with "Convert data Types" = True, it seems that the data type it tried to convert the UDT to was not compatible with SQL 2000.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply