Database Replication, does it update as the DB grows ? 1

[Skewiff]

I had set up replication between my servers just after they were set up and the software loaded ..

Im just in the process of deleting and recreating the replication and have found something I wanted to run past you all.

The previous snapshot listed 137 articles, the current new one - 680. I know that the DB (sun) does create new tables as new companies come on line etc.

Does this mean that although my intention is to transfer sundb in its entirety, I am actually only transferring the specific articles listed at the time of replication setup ?

If so, I need to start considering how Im going to manage the process

 

[bdiaz]

You are right, you are only replicating the articles listed when you created the replication definition unless you chage the published database schema through replication properties (or replication stores procedures)

Hava a look to "Schema changes on publication databases" on BOL.

 

[Skewiff]

excuse me , BOL ? Im a touch new at this and dont recognise the TLA ;-)

 

[bdiaz]

Book OnLine, the SQL Server manuals; you can install them with SQL Server, or find them in Microsotf web pages.