Database Replication
-
Dear All, I have a Point of sale system (Desktop application) , this system will be deployed on three different branches and one factory branch , we have also a dedicated server hosted online ,all places including the dedicated server having the same schema , i would like to replicate the new changes from branches and factory to dedicated server and vice versa , i tried to use merge replication but in vain , we could not set it up properly , we faced a problem with user account permissions , we got that message "Could not connect to distributor "DedicatedServer". Could anyone please have a solid procedures to solve such a problem? or if there are some third party tools that could help us achieving that task ? Your Response is highly appreciated !
Human knowledge belongs to the world.
-
Dear All, I have a Point of sale system (Desktop application) , this system will be deployed on three different branches and one factory branch , we have also a dedicated server hosted online ,all places including the dedicated server having the same schema , i would like to replicate the new changes from branches and factory to dedicated server and vice versa , i tried to use merge replication but in vain , we could not set it up properly , we faced a problem with user account permissions , we got that message "Could not connect to distributor "DedicatedServer". Could anyone please have a solid procedures to solve such a problem? or if there are some third party tools that could help us achieving that task ? Your Response is highly appreciated !
Human knowledge belongs to the world.
What database system are you using? Oracle, MS SQL, Other? I assume MS. It sounds like a permission problem. Might I suggest creating a SQL login with the desired permissions on all systems.
-
Dear All, I have a Point of sale system (Desktop application) , this system will be deployed on three different branches and one factory branch , we have also a dedicated server hosted online ,all places including the dedicated server having the same schema , i would like to replicate the new changes from branches and factory to dedicated server and vice versa , i tried to use merge replication but in vain , we could not set it up properly , we faced a problem with user account permissions , we got that message "Could not connect to distributor "DedicatedServer". Could anyone please have a solid procedures to solve such a problem? or if there are some third party tools that could help us achieving that task ? Your Response is highly appreciated !
Human knowledge belongs to the world.
I'd have to know a few more details about your infrastructure to provide better feedback as to a course of action. You may want to review this excellent series of concise articles on SQLServerCentral regarding SQL replication and how to choose the correct model for your needs: http://www.sqlservercentral.com/stairway/72401/[^] Best of luck!