Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mindreader13
Starting Member
6 Posts |
 Posted - 2007-09-20 : 05:08:17
|
| Hope to be my last question.I used Transacational with update sub method. When adding new column to replicated table. Do I need to generate new snapshot again? Just want to know how can I apply the new schema to subsciber DB without doing all regenerate snapshot, recreate all tables and bulk copy.. Please help |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-20 : 23:58:15
|
| You can replicate schema changes in sql2k5. |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-21 : 00:14:18
|
| If you are using 2005 replication you can directly make schema changes as you would if there was no replication. In 2000 you had to use some special stored procs but not anymore in 2005.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
New column for replicated Table