Adding Column to Published Table

snehanshu

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???????

falk

Unfortunately there is no way to synchronize the Attain repository and SQL Server. What you can do with transactional replication is the following:

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

dmccrae

In Attain, if you change the LinkedObject property of the table in the table designer to Yes, and save, then design again - can you not then add the field that is already in the SQL table ? This used to be possible. Then you set the LinkedObject property back to No.