more quick actions
minimize quick actions
Topic starter
Hello all,
We are working for a migration v8.1 > v11.1 of a big project composed by 6 couples of redundant server + 2 client + 2 historical server.
Since they encountered some troubles in v8.1 with the HDS replica of the database, I wondered if it was the case - due of the size of the project - to switch to SQL Server native replica instead using HDS replica. I heard many times, during our ITM meetings, that SQL Server replica is more efficient than HDS one.
Any of you have experiences about databases replication using SQL Server native replica? I'm interested to know what is the behaviour/HDS configuration in this case:
- Whick kind of replication we need to configure? Transactional replication?
- Can HDS continue to write records during the replication?
- About replica direction: is it necessary to configure replica in SRV_A to SRV_B and the opposite? Or one side only is enough?
- About maintenance plan: is it necessary to configure the maintenance plan (Defrag...Purge... etc) on both PcVue machines or only in one?
- Any other thing to take care?
Any feedback is welcome.
Thankyou
Filippo
Posted : 22/10/2015 8:18 pm
Hi Filippo,
Personaly I'm used to create only one bidirectional replication.
In my opinion the most imortant point for success is to calibrate the number of step correctly.
I try to have one step for 3 minutes. So depending on the period it can be a lot of step but I think it is good not encounter some time out issue in case of many many data to replicate.
Posted : 23/10/2015 11:58 am
Hi Filippo,
1. I am not sure that we said SQL Server replication is more efficient than HDS replication. What we said is that it's always better using buit-in feature instead third party.
2. Keep in mind that replication is not allowed between 2 SQL express edition. But it is available between 1 Express TO 1 no Express.
Now about your questions:
Whick kind of replication we need to configure? Transactional replication?
I dont know. Better Arnaud replies to this one.
Can HDS continue to write records during the replication?
I think yes.
About replica direction: is it necessary to configure replica in SRV_A to SRV_B and the opposite? Or one side only is enough?
If you dont make bidirectionnal replication you can have some "Data Holes".
About maintenance plan: is it necessary to configure the maintenance plan (Defrag...Purge... etc) on both PcVue machines or only in one?
It's not the good way to say. I would say: You must maintain each Database PcVue is using.
Nico
Posted : 26/10/2015 8:45 am