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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-12-01 : 05:56:29
|
| Dear All,i've a database with 14 big tables in replication. now i need to add a new table to the replication. now it is necessary to generate a new snapshot? or is there any other way?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-01 : 12:24:21
|
| You can do through GUI feature by adding Article while running snapshot agent, it will only generate for new article. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-02 : 00:33:37
|
| can you brief me in this regard....what is the starting point for this....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 09:24:26
|
| In publisher Properties- Articles- Choose new table.After that restart snapshot agent.It will only generate snapshot for 1 article thats how 2005 replication is built on. |
|
|
|
|
|
|
need to add new table to the replication