Sync Online Sql server database with offline local database.

Can you please provide the structure of both the tables as there might be some stuff that will generate different ids .. E.g Table name = Cutomers --> CustomerId is auto generated column in both the databases For record #1 Customer id= 1 When C# application runs it will copy the Customer information,but due to auto generated column it will generates a different if in online database that might be a problem for other stuff. Please message me so that w could discuss in details.

Hi good to see you i am a full web developer with over 5 years on freelancer.com. ****In SPECIAL very familiar with ASP.NET, .NET, C#***** I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about your project. Looking forward to work with you soon.

i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java, ReactJS, NodeJS) and Mobile (Native and Hybrid). I am also an expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery. I have over 5 years industry experience in development and graduated with a Masters Degree in IT from the Hong Kong University. My PHP L1 exam score in Freelancer places me in the top 3% of developers. Please have confidence in my skill and quality of work. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will also do my best to correct any area of work where quality comes into question, I want to have pride in my service to your company and the final product provided. While I am happy to make adjustments and alterations as your project progresses please understand that I am a dedicated freelancer and any work that is substantially different from the project description may need the awarded fee to be re-negotiated. Feel free to contact me if you have any questions, and please review my 5 star profile. I look forward to working together in partnership on your project and into the future. Regards

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

I am a Dedicated Senior .Net Developer and Database Administrator with 20 years of experience in Web/ Windows and Android Developments,Administration, Project Management System analysis, and Database Developments. Delivering quality solutions to complex business problems within scope, budget and tight schedules whilst meeting strict specifications both functional (for users ) and technical (for Developers) , from project planning, estimating to delivery. SKILLS AND ABILITIES • Web | Windows Developments • C# | Vb. Net | ASP. Net • SQL Server | MY SQL | EXCEL | MS ACCESS • MVC| | Web Forms | Win Forms • Web Services | API • Entity framework | nHibernet • Java scripts | J query | json • HTML | PHP • CSS | Bootstrap , • Android Developments • IIS | Windows Server 2017 • Crystal Reports | iText Sharp • XML | XLT • System Analyst • Agile | Scrum | Waterfall Developments

Hello, I am interested in your project, because i have done similar syncing recently from local sqlite to remote mysql and local mysql to remote mysql. Let me introduce my self first. I am an experienced full stack developer, with an original background of .NET development. Later i started developing web projects in laravel, PHP. I have recently developed a point of sale system for my client which has desktop app developed in .NET and web backend developed in laravel. The desktop app works with a local mysql db in offline mode, then after some interval we post partial chunk of data to laravel api, to avoid primary key duplication issues (in case of distributed system) we use guids. Coming to the cost, it will depend upon number of factors, 1. Number of tables you want to sync ? 2. Whether the structure of local and remote db will stay same or they can very ? 3. Do you already have some backend api ? 4. Your local data will be one machine or will come from different machines (like POS) ? 5. Finally, what is the current structure of your tables, are you using guids or primary keys ? Let me know if you think i can assist you in this project. Regards, Muhammad Shafeeq

Hello, I have checked the requirements. We can discuss further on this task in more details in PM. Thanks.

Hi There, To sync local and online DB server you would need a dedicated synchronization service and changes to your application as well. There is no out of the box synchronization service which can sync two ways online to offline and offline to online simultaneously. I had developed similar synchronization service for marine domain where data is entered on merchant ships and syncs with the shore office and vice versa. Let's connect over chat to discuss more. Regards, Shobhit Pundir

Hi there, We can sync your db data. Please provide access details to review the database. Thank you!

Hello Sir, I can help you with the sinchronization bewtween your 2 databases. But I need more info about the size of the database... If it is a very large database my bid would rise a bit, the complexity would increase. If you are interested let me know. Thanks, Alex

Hi, What i understand in your requirements is that when ever any schema or data changes in made on local database its automatically changes into live database in a particular time interval right? We can talk on chat of your task details if you want. I will start your project as a highest priority when you share your details requirement and if you award me this project then I will bound to give you my best performance because then you only give me 5 star. you can see my profile and review also. And you don’t need to do any advance payment, after completion of project and if it's all ok then you do payment. Thanks Sandip & Team

Hi. i am a full web developer with over 5 years on freelancer.com. ****In SPECIAL very familiar with C#, ASP.NET, MSSSQL***** I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about your project. Thanks. Best Regard

Hello there! I am Vinícius, I've two year of experience in .NET platform, developing desktop Apps, mainly ERPs. The most applications i work utilize SQL Server as DB, which I mastered. Final year as graduating of Software Engineering Bachelor. The Project in my conception need to allow, both the source and the destiny of sincronism, to be changed any time, as well as define what tables and DBs will be synchronized. Do you would like an App that synchronizes when is executed ? Or in a specific set time? Do you would like an Interface for the App? Or a console application then would solve your needs. I make myself available for any change and discussion about a solution that meets all your and your employees needs.

Hi. I think i can do this job without any app. We can link the server together and make some stored procedures to copy your data locally. I have 2+ years experience in sql server databases.

Hello, I'm Juan Pablo Villa, software engineer from Azul, Buenos Aires, Argentina. I'm .Net Sr. developer, expert in C#, SQL Server, MVC Core, SSRS, SSIS, Azure VM/Database, EF, GIT. I was in several similar project, but I need more information about the tables, and the SQL server versions. We can use C# program, but it could be easier and more effective a SSIS package that migrates the data. I just start with freelancer, and I need a reputation best regards Juan Pablo Villa