Post reply

Altering a published table

  • July 13, 2004 at 12:33 am

    #88162

    We have a published merge-database, subscribed to by about 10 laptops with MSDE, who synchronize all data every now and then from their home using a ADSL connection.

    I know how i can add or remove a column from a table to the publication, but is there a way to alter a column i.e. from Varchar(50) to varchar(100)? My only idea is to add a new column with the new definition but that means I have to chance the application that uses the database and distribute the new executable to all the laptops. The laptop users arent exeperienced enough to update the application by themselves 🙁

    Anyone know the answer?

    Bas Schouten

    CBIS BV

  • July 13, 2004 at 1:14 am

    #514338

    You will have to DROP the Publication, make the modifications on all Databases(Subscribers) and then recreate the publication without doing the initial snapshot. Alternatively, if the Databases are small enough, then just do the initial snapshot again.

    Kindest Regards,

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

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