Hi,
We have replicated certain tables (e.g. G/L Entry) between two servers. its working fine for last 6 months. Now I want to add a column to one of the tables. I can do it from navision by dropping all the subscription & Publication First. But I don't want to use this process due the complexity of the publications and high voume of the data already entered into those tables. so restarting the replication will be huge task.
Another process is adding column from SQL server enterprize manager or using Transsact SQL Commands. I already have added one column in a particular table using this process. But the problem is that this new column is not visible from C/SIDE.
Is there any way i can use this column from C/SIDE. Or are there any other ways of adding columns in published table without reinitializing the subscription. Do you have any suggestions???????
0
Comments
1) Make sure no user can access the database or doany modifications in the table you are going to modify
2) Delete all subscriptions to the publication you're going to modify
3) Modify the table using the Navision/Attain client on both servers. If only the publishing server has Attain then do the modifications manually on the target server.
4) Recreate the subscriptions this time indicating that subscriber has all data. In this case no snapshot will be created and applied.
5) Use sp_script_synctran_commands (included with SQL SP3) to update repl. triggers on the subscriber.
SY
Falk
This posting is provided "AS IS" with no warranties, and confers no rights.