any other tools for replication

Last Post 24 Jun 2006 01:54 PM by TRACEYSQL. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
TRACEYSQL
New Member
New Member

--
24 Jun 2006 01:54 PM
Hi currently we use sql replication that takes the entire database from server 1 to server 2 which is used for reporting on.

We have a small problem is that our erp does not come with primary keys so all of our tables have to be changed and so each time we have an update we have to stop the replication stop subscriptions and then reapply the snapshot.

Is there any thing else i can use...i read about log shipping but don't fancy that doing it through backups etc....

any other ideas.
You are not authorized to post a reply.

Acceptable Use Policy