August 26, 2003 at 8:21 am
What is the best process to setup the SQL replication with in the same instance between two databases. Please let me know which artical of Microsoft I need to refer.
venkatesh
venkatesh
August 26, 2003 at 9:03 am
Adding to previous , what is the best replication type can be configured for transfering data from source database to reporting database in some time intervals
venkatesh
venkatesh
August 26, 2003 at 7:10 pm
Depends on whether you need to have the subscriber offline and whether you wil be updating the subscriber. In general I recommend transactional until you find that you need something different.
Andy
August 27, 2003 at 9:15 am
Hi Andy,
Transactional type is working fine for me, where ever i update source , snapshot agent is updating subscriber, But if i create any tables/objects how this will reflect in subscriber, what Replication type i need to use. This is first time I am doing replication.
venkatesh
venkatesh
August 27, 2003 at 10:32 am
After creating subscription and while running it comes out with an error
"could not able to find stored procedure SP_MSupd_EscalationJobControl".
venkatesh
venkatesh
September 12, 2003 at 1:33 pm
when I setup a snapshot replication , will there will be any columns will be added to source database tables to keep track of the transactions. It happend to me while setting the replication between the two databases on same instance. Is there any way we can replication with out adding columns to the source database tables because some jobs were failing and mainly this application database is a third party application Changeipoint . Please give some tips ASAP.
venkatesh
venkatesh
September 12, 2003 at 9:17 pm
For transactional it will not add columns (but you have to have a primary key defined on the table in order to select it). If you want to use queued updates (or merge repl) it will add a uniqueidentifier to the table. Usually this doesn't break anything, but it does need to be tested.
Andy
September 15, 2003 at 11:28 am
where I can find stored procedure 'sp_MSupd_escalationjobcontrol' because one of my transactional replication job is failing.
venkatesh
venkatesh
September 15, 2003 at 1:49 pm
Why is it missing? Those shouldnt be touched by users. Take a look at the proc sp_MSscript_sync_upd_proc. You can also fix it by just doing a new snapshot.
Andy
September 15, 2003 at 3:05 pm
The proc exists but only the the above proc is missing. let me know how to fix it.
venkatesh
venkatesh
September 18, 2003 at 8:12 am
Can some one through some idea how to debug this error in replication
"The row was found in subscriber while applying replication command" in publisher agent .
Thanks
venkatesh
venkatesh
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply