CODEWITHSUNDEEP
sqlsql-serversql-server-2008replicationdatabase-replication
Ruan du Preez
Ruan du Preez

Reputation: 99

Data Replication - SQL Server 2008

Good day

I needed to create a data replication between two databases. I created the Local Publication with one table for testing purposes. I then created the Local Subscription and it worked 100%. I tested it and the data gets updated. I then started to add more tables to the Local Publication that I created. I noticed that the new tables did not pull through to the new database through the Local Subscription I created. Do I need to create a new Subscription for the updates? Do I need to delete the current Subscription or is there another way that I can just update the Current Subscription?

Thanks

Ruan

Got this description from this Article: http://www.mssqltips.com/sqlservertip/2502/limit-snapshot-size-when-adding-new-article-to-sql-server-replication/

Upvotes: 1

Views: 221

Answers (1)

tungula
tungula

Reputation: 578

You must start snapshot agent, but check that already replicated tables are not marked for reinitialization, because in such case data from old tables will be transfered once more.

Upvotes: 1

Related Questions