July 27, 2011 at 7:51 am
is it possible to configure replication from sql 2000 to sql 2008 ?
if yes , what changes do we need to made an how to cofigure transactional replication ?
July 27, 2011 at 8:04 am
ramyours2003 (7/27/2011)
is it possible to configure replication from sql 2000 to sql 2008 ?if yes , what changes do we need to made an how to cofigure transactional replication ?
Yes this is possible to configure. I always prefer using enterprise manager to create a new publication rather than using management studio. Give it a try the way you would have set up replication in a common way.
PS: Only transactional replication will work and not merge.
Thanks
Chandan
July 27, 2011 at 9:05 am
Just one note to Chandan has specified. The distributor should be the same or higher version than that of the Publisher.
When registering the SQL 2008 on your Enterprise manager, it might show error, Just continue and it will go OK.
-Roy
July 27, 2011 at 12:21 pm
Roy is correct here. Enterprise manager will refuse to connect to sql 2008 version but keep pesturing it till it gives up and says' Do you still want to register it'
Now in the server group in the object list pane in enterprise manager, you will see your server listed here. Just leave it as it is and continue with your replication. Let us know how it goes from here.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply