October 21, 2010 at 6:29 am
Hi,
please let me know will the data replication happen between 2 database, where in the database is in the source has two tables with dbo.tablea and myschema.tableb
Please let me know if i have to do some thing to make it happen as of now its not happening in my testing environment.
I have noticed one more thing, few tables with myschema.tablessss have been replicated but few have not, and one morething i found is the table MSArticles in distribution database has only 711 entries of tables where in the tables in our database has 740 tables, i have not used any filter on the tables.
also noticed that the tables which are not in the distribution db is not getting replicated. so how to solve this issue.
please help
October 21, 2010 at 12:59 pm
Replication works fine for tables that are in schemas other than dbo
How are you adding the articles for replication - i.e. are you doing it from the UI or are you using a script using sp_addarticle?
It is easiest to troubleshoot if you create a script to add the article that is not being added (myschema.tableb in your example) and then run the script in SSMS and see what happens. If using a script with sp_addarticle make sure to start the snapshot agent (sp_startpublication_snapshot I think does this) after adding the article (assuming you're initializing via snapshot).
And does replication monitor show any errors?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply