This entry was posted on Wednesday, May 25th, 2005 at 1:01 pm and is filed under Uncategorized, Tech data. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
This document is design to provide a procedure for any one wanting to make structal changes to a merged database.
The Topic covered are:
• Add a column to a table
• Remove a column from a table.
• Alter a column
• Drop a table
• Add a table
Note: If you want to make changes to a table that is not being replicated then you do not need to follow any of the procedure here, just apply the changes as per usual. It is only table that are part of a Article that require these changes. To find out what tables are part of a Article you can either checkin the properties of the publication, but Enterprise manager will stop you from making changes anyway.