I've a requirement in replication.
I've a regional site and 4 local sites, each have SQL Separate SQL Server and an application database. Whenever there is a data updation in the local site, the data will be updated in the regional site thru application.
Every night, data needs to be replicated from regional database to all the local databases and should be done in the shortest possible time. Suppose there are two sites A & B and a regional database. A record is inserted into one of the tables in site A. The corresponding changes are done in regional db. So, during this night, data will be replicated from regional db to site A and site B. If transactional replication is implemented, PK violation will come in site A. DB size is around 50 MB. So, snapshot replication will be very slow.
Can any of you help me?
Thanks in Advance,
Manohar
I've a regional site and 4 local sites, each have SQL Separate SQL Server and an application database. Whenever there is a data updation in the local site, the data will be updated in the regional site thru application.
Every night, data needs to be replicated from regional database to all the local databases and should be done in the shortest possible time. Suppose there are two sites A & B and a regional database. A record is inserted into one of the tables in site A. The corresponding changes are done in regional db. So, during this night, data will be replicated from regional db to site A and site B. If transactional replication is implemented, PK violation will come in site A. DB size is around 50 MB. So, snapshot replication will be very slow.
Can any of you help me?
Thanks in Advance,
Manohar