SQL Server Performance Forum – Threads Archive
Add/drop colum in repl DBHi..
I would like to know what would be happen if I just simply add/drop the column in repld db??? Or If I have added extra tables/column in production db do I need to do the same thing in repl db or do I need to rerun the snapshot agent?
You can use sp_repladdcolumn sp_repldropcolumn to add or drop columns to a previously replicated table. You can also modify this via the UI on the article properties page. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
If you add a new table to the publication, you will need rerun snapshot agent. WBR, Vlad A. Scherbinin
Rerun the snapshot but it does not replicate the new table.
Last action msg: A snapshot was not generated because no subscription needed the initialization
please refer the following in order to drop / add column to replicated db : http://www.microsoft.com/sql/techinfo/tips/administration/addrepltablecolumns.mspx
http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm Regards. hsGoswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami
I wanted to know how do we replicate the new table from publisher to subscriber..
I know how to add/drop column…
so is there any way that i can replicate the new table without initialize the shema and data ?