August 8, 2008 at 10:57 am
Hi All,
Around 55 tables are to be replicate to the reporting server, when I made transactional replication and tables are also replicated to the reporting server but few tables have only the structure without data and most of the tables have been migrated properly.
When I try to investigate in this, I found some difference between the replicated and un-replicated tables. The table property which has False at "Table is Replicated" (Right click Table->Property->under the replication section) those table are having the problem and of them are properly replicated.
Since, its in read-only mode I couldn't able to make it as True or False besides, I am not sure, this could be case for my replication problem.
Please help me if anyone could able to resolve this.
Regards,
Mohan
August 9, 2008 at 11:01 pm
I have a feeling those "un-replicated" tables are not included in the publication in the first place.
On the publishing database, run the following
select * from sysarticles
where name='un-replicated table name'
and see whether you can get any record back.
HTH,
JY
August 10, 2008 at 2:50 pm
Hi Jeffrey,
After executing the sysarticles table I couldn't find any records.
However, at the initail snapshot creation records haven't been replicated but at the time of job schedule (may be 12:00 AM everyday) records been replicated to the destination server. I couldn't understand what would be the reason.
Since, its development server its Okay, but I am little bit scare to do this activity at Production platform.
Regards,
Mohan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply