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 |
|
Superdoc
Starting Member
2 Posts |
 Posted - 2012-04-21 : 12:47:16
|
| Hi,i'm new to the replication, i've done a transactional replication on a test environment, publication, distribution and subscription all on same instance, what i noticed was that new table added wasn't getting added as an article in the distribution, but if i changed or added column/data to existing article it worked, is this a limitation that new tables created in publication doesn't get created in distribution or if i haven't properly understood. ThanksRegards, |
|
|
Superdoc
Starting Member
2 Posts |
Posted - 2012-04-22 : 09:23:07
|
| i found it myself, whoever is looking for answer for same is this.it also create article that is ready for immediate sync for only that one name and not necessary to take snapshot of entire database.sp_addarticle 'publication1' ,@article='table1',@source_object='table1',@destination_table='table1',@force_invalidate_snapshot=1Regards, |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
|
|
Publication Database is not creating new articles