Find Jobs
Hire Freelancers

Database Sync Complex Logic

$500-1000 USD

Chiuso
Pubblicato circa 5 anni fa

$500-1000 USD

Pagato al completamento
I need a solution for syncing(instant) databases (Sql Server) between various locations. I am not sure that whether there exist some 3rd party component which can solve my problem or this sync part needs to be done manually. Please read below my problem statement and come up with your inputs. A company is located at 4 different locations. One of them is HeadQuarter(HQ) and other 3 are termed as Site Locations. Lets say Site A, Site B & Site C. All of these locations (HQ + Sites) has frequent internet connectivity issues and that is one reason that we have deployed same application+database at each location(HQ + 3 Sites). Application is an Asp.Net MVC website & database is in Sql Server. We need data to sync fast between various locations if internet connectivity is available or as soon internet connectivity is restored. For each entity(table and dependent tables) we have master-slave concept. In other words, few entities need to be sync from HQ=>SITE(ALL) and other entities need to be sync from SITE(EACH)=>HQ I am looking for some solution to this problem. I will provide sample database along with detailed description. I will prefer some kind of 3rd party solution over manually creating a sync component. PS: People are suggesting me Sql Replication service or Sync Framework. Please provide your inputs on this too as my case is that I have multiple databases and transaction can happen on all of them at same time. So how much reliable Replication or Sync Framework is for this case.
Rif. progetto: 18455428

Info sul progetto

26 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
26 freelance hanno fatto un'offerta media di $851 USD
Avatar dell'utente
Hi, you don't need to use any third party component for this, we can achieve this with sql server replication. I can set this up for you. I have 8+ year exp. in asp.net mvc c# web development and deployment. Thanks Girish
$833 USD in 10 giorni
4,9 (383 valutazioni)
8,7
8,7
Avatar dell'utente
hello,how are you. i read your bid carefully. i am C#, .Net, Sql Server expert and have full experience for 7 years. C#, .Net, Sql Server is my top skill and i can build your project by using . I can provide most quality and high fast. if you want to success, please contact me. Then, I will give you good result. hire me.
$800 USD in 10 giorni
4,8 (8 valutazioni)
5,7
5,7
Avatar dell'utente
Hi sir, i have read your requirement carefully. I suggest use MS SQL Replication . I can do database sync perfectly and exactly without any risk. If you wanna confirm me, please check my work history and portfolio kindly. Then, you can know about my ability that can do your project enough. Especially, this is my experienced and successful work before. Also i have fluent English skill, so you can communicate with me very easily via voice call and thus, you can save your time. No problem for working with me now. So if we work and do our best for one purpose, we can get great success each other. Please call me and discuss about your project seriously, then you can be at ease about your project. I'm always here and ready to talk with you right now. I'll wait for your call. Thanks.
$1.000 USD in 10 giorni
4,5 (34 valutazioni)
6,3
6,3
Avatar dell'utente
Hello, Hope you are doing well! I have worked on similar projects on this platform recently. One is still active (ongoing since March 2017), working smoothly with SQL Server Merge Replication. Another one is successfully completed (in 7 days, in Oct 2017, repeat hire 3x times) with SQL Server AlwaysOn Availability Groups. Sharing the links here as quick reference. #1. Looking for remote DBA and Data sync expert https://www.freelancer.com/projects/microsoft-sql-server/Looking-for-remote-DBA-Data/ #2. SQL 2016 Standard set up AG https://www.freelancer.com/projects/mysql/SQL-Standard-set/ #3. Project for Devendrakumar S. https://www.freelancer.com/projects/mysql/Project-for-Devendrakumar-15673731 Please allow me to have a discussion with you. There are many variables which need to be considered before finalizing the synchronization method. I'm sure, I can help you pick and implement a method which works best for this business use case. Please find me on Skype as Devendra_Shirbad (Devendra Shirbad aka 'Dev'). Thanks & Regards, Dev Director, Dhanu IT Services
$600 USD in 10 giorni
4,9 (7 valutazioni)
5,4
5,4
Avatar dell'utente
Hi, I am full time freelancer from Pune and having around 14 years of experience in .net and MVC, SQL Server. I have developed data synchronization services in past which sync data from Central server to client machine and vice versa. Before I propose solution I need to understand that Is SQL Server is deployed on Dedicated IP of each site and HQ ? If no, then we have to create some web API on HQ machine and console app on Site server. We can discuss details on chat.
$750 USD in 20 giorni
4,9 (23 valutazioni)
5,0
5,0
Avatar dell'utente
hello sir , i can do this work please inbox me .. i am passionate programmer... i can do it give me some time i have 10 years experience in software and android development and web development in asp.net c# mvc technology , i can do your work as per your requirement. let me know if my profile suitable for your project. thanks
$1.111 USD in 15 giorni
4,9 (11 valutazioni)
5,1
5,1
Avatar dell'utente
Hi There, I can give you solution and by using solution different SQL Database will be synchronize each other. for that we need to change some database design / structure. - I have already apply this type of solution in my one of recent project. that have similar connectivity issue and they want to capture orders offline and whenever system get connectivity synchronize with live database. Website build using similar technology MVC .Net, Sql Server, Entity Framework etc. Looking forward. Thanks
$800 USD in 10 giorni
4,8 (13 valutazioni)
4,4
4,4
Avatar dell'utente
Hello There I have checked your job description and ready to provide ongoing support, changes, adding content, fixing bugs, regular support, etc and with website design work for you. I have developed thousands of websites in many programming languages for clients all over the world. Please Send me a message so that we can discuss more about this project. could you please inbox me more detail about this project. Best Regards, Thank you
$835 USD in 13 giorni
5,0 (3 valutazioni)
2,6
2,6
Avatar dell'utente
I have successfully delivered many projects in many different company and clients. I have a strong Programming and Management skills and always updates myself with Research and Development of new technologies to strengthen my knowledge and skills.
$870 USD in 14 giorni
5,0 (2 valutazioni)
2,1
2,1
Avatar dell'utente
I have been in this field for more than 7 years. i have experience in C#,php,Perl,wordpress,Html,postgress ,Ubuntu,Crontab,Web Services, Rest Api, Zend ,YIi,Mysql. Relevant Skills and Experience so i am right candidate for your project because i have experience in C#,Perl,php,node.js,Ubuntu,Crontab,Crypto currency,Wordpress,Ebay,Amazon,Instagram,Mysql,Sqllite,Mongo Db, Soap Api projects.
$944 USD in 20 giorni
5,0 (3 valutazioni)
1,8
1,8
Avatar dell'utente
Hi Sir/Madam, Thanks for this project. Hope you are doing great. I have great knowledge about ASP.NET, MVC, PHP, MSSQL, HTML, IONIC, React Js, Node Js, Bootstrap and AngularJS etc.. We are working last 10 Years in this sector. We have worked with many websites like- T-Mobile, Trekteller, Tripoto, Orion Hyundai...etc. Also comfortable to work any rotational time as per the requirement. This project totally likes my work and skills. Kindly share more details about the project. Thanks Again. Have A Good Time.
$722 USD in 10 giorni
5,0 (1 valutazione)
0,9
0,9
Avatar dell'utente
Hi There. have got over 6+ years of experience in Asp.net. Also, I provide you my CV on chat after connection. Some of the expertise in .net is: - Programming Language: C, C++, C#.net, VB.Net, Angular - Web Technology: MVC, Angularjs, CRUD Operation- Peta Poco ORM, Dapper ORM, Entity Framework - Database: MS SQL 2008, MSSql Job Scheduling, Google Chart API I provide quick turnaround to all clients so that if a client is giving money they need something robust. I will give you all the support. Let's discuss your amazing projects! Thanks & Regards, Kinjal Patel
$925 USD in 45 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello client, I can do youre task using separate service. I'm working as associate software engineer. I have 2.5 years experience asp.net, c# mssql. contact me i can give my idea and start work
$750 USD in 15 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi There, I have a project similar to your request. In HQ I defined the some table for master data In SITE master table also define the same in HQ and a Application (.NET) bulk copy is the fast solution for data transfer from HQ --> SITE and SITE --> HQ ( can analysis first and then send to HQ) I want to clarify more details, if you believe please connect to me Deni
$800 USD in 12 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I have questions. do all SQL sites run enterprise edition. what version of SQL. Do all tables have a primary key column, single column such as an identity or a guid/rowid. what time zones do the servers reside in. these are all factors that need considering and more questions before anyone can say they can do the task using SQL server merge or peer to peer or bidirectional replication. a simple example, if table a has an identity column and data is inserted at both sites, the id will be in conflict, multisite tables may need to be partitioned per site.
$1.000 USD in 20 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Greetings !!! I just read your Project Description and I m willing to go ahead and start Supporting on this work of Database Admin with Data Sync. I have done this kind of work recently for Microsoft where we have sync from various locations Data ware house . I have 10 year working experience on multiple Database Project based on MS SQL server, mysql and Visual Studio ,SSIS and other ETL Projects . I will work in Strategic milestones and transparency so that you will be frequently uploaded on where we stand in the project i can achieve the result that you are looking . Looking forward to hearing at your earliest convenience. Thank you Avin esh
$506 USD in 8 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
More suitable choice here looks merge replication with peer to peer topology so if any of site down and will come back it will synch up with other sites. Another solution is to configure Always on Databases between mutliple sites using windows cluster as its OWN Sql server feature to synch up with site when back on network. it may fire unhealhty always on alert may require little manual intervention but using Ideal monitoring alerts can avoid delay. Asynchronous configuration not suggested in this scenario but synchronous will work smoothly without any delay of commited data [this can have very minor latency if same data being written on one site and reading from another site in synchronous mode can have different result as after commit it will replicate] We have plenty off prerequiste to cover and discuss before implementing this solution and require through testing before deploying to PROD environemnt.
$1.666 USD in 30 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello Employer I have very good experience (3 years)in integration services. I am wokring with one big US based company where they are using more than one software . i build so many integration for that company last 3 years. I would recommend develop this integration using Microsoft Could (Azure ) integrations services like Azure logic app and Data factory which make development time faster and give visualisation of data move between integrations. looking forward to more discuss on this point. Thanks Sahadev Dodiya
$500 USD in 9 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
software development experience in C# including high transactional enterprise e-commerce and ERP applications, with team leadership and mentoring experience.
$800 USD in 30 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: INDIA
New Delhi, India
5,0
34
Metodo di pagamento verificato
Membro dal mag 16, 2010

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.