Post reply

SQL 2000 replicate a ntext column to SQL 2005, OK ?

  • April 28, 2008 at 8:58 am

    #189826

    Can I do these things :

    (1)Use Transaction Replication, replicate a SQL 2000 database to a SQL 2005 database ?

    (2)Some of the SQL 2000 data columns are ntext, can we replicate a ntext column ?

  • April 28, 2008 at 9:16 am

    #807874

    Yes, you can do both.

    Replication from 2000 to 2005 works fine, but it can be a bit trickier to set up. I have found it easiest to configure the publication from Enterprise Manager on the SQL 2000 side and then configure your subscriber using Management studio.

    NTEXT can be replicated, but it slows things down significantly. Try to avoid them if possible (perhaps you do not need them on the subscriber). You could also replicate everything but the NTEXT columns and synchronize these fields in another way.

  • April 29, 2008 at 2:59 am

    #808185

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply