December 15, 2004 at 9:10 am
I am currently attempting to add a column to a table that is being replicated. However it will only let me add the column to the end of the table. Is there any way, without redoing the publication to adjust the position of the column in the table?
Any help or suggestions would be greatly appreciated.
Thanks
December 15, 2004 at 9:52 am
I had to do something similar a while ago. I think I did something along the lines of:
- Script out the steps to delete the publication and save it.
- Script out the steps to create the publication and save it.
Then I think I ran just the portion of the delete script that dealt with the table you need to remove that table from the publication. (My publication had 10 or so tables)
- Modify the table
- run the portion of the create script for that table to put it back in.
I usually set up a test publication to experiment with these kinds of things. Make a table with 1 or 2 fields and go through the steps to make sure it works.
December 15, 2004 at 11:14 am
My question is why do you care about the column order? Yeah, I know the replication add column procedure adds something onto the end of the table, but if you're using queries / views to access the data, you can specify the column order. The order of the columns in the table is actually irrelevant.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply