Sync SQL Data on two different locations via .Net sofware.

Hello, I am very much interested to do this work by C# as i have strong knowledge on C# as well as ms sql server. Let me know few more detail plz, if your are interested. Looking forward to have a positive response. Note: Is both the sql server accessible over internet? This is one of a related project i had done. https://www.freelancer.com/jobs/SQL-database-programming/MSSQL-migration-Scheduled-Task-another/ Thanks

Hi Sir/Madam. Please send details. Thanks .................................................................................................................

Dear Sir, This is Sikander. I am having 14+ years of experience in software development and I am ready to start this job. Please discuss with detail project specification, So, I can give you exact time frame and budget for this project. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander

Hi there - My name is Faridoon. I’ve read your project requirements and can see that you’d like to trigger the updates which is been done on the main server and replicate it on backup server and timer function should check the changes in every 5 minutes. We are highly qualified for this project and would love to speak with you further about taking this project on. We will complete your project within the allocated time with the best of our efforts.

hi, I am interested to develop a .net program to synchronous between database in two different location. The program can be run by windows scheduler and windows web service. please see my profile and let me start with the development of appropriate application. Thanks Prakash

Hi, I have designed a similar application in C# with Microsoft Sync Framework to sync two SQL Server databases with different schema also. Only problem with this solution is that, Sync framework will create metadata tables for each database table to track changes. I have 9 years experience in C#, ASP.NET, SQL Server and SSRS. Thanks

hello my name is umer and i have over 15 years of s/w dev. exp. I have db synching many times and have perfect idea for how to acheive it easily live without any .bak file. jsut contact me and ill complete this fo ru asap

Hello Sir, Greeting for the day, Hope you are doing well I am Working with Data Center Organization as a Software Support Engineer, I have more than 8 years’ experience in Windows/Linux Server administration , Website Hosting (Cpanel/Plesk) migration, Mail server configuration management ,CISCO Router Switches, Firewall(ASA,PIX,Sonicwall, cyberoam) ,Cloud Computing(AWS/Azure,office365).I read your Requirement and able to perform task successfully. Please add me in Skype (karunakartiwari) for details discussion about your requirement. Thanks karun

Hello, I am ready to start and will deliver within 8 hours. PM for details Thanks in advance .

Hi My proposal is to use replication. I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hi, My name is Richard and I am from New Zealand. I have done SQL Server sync many times without using the build in log shipping and mirroring tools - the "quick and dirty" non-enterprise way. I just need to know whether your SQL servers are behind web hosting companies, or on-premise across two office locations. This will influence whether the replication is done via Windows Service, or by Plesk scheduled task. If your tables do NOT already have time-stamp columns, then you have 3 choices: - ship new records only. updates to old records may not be transferred - ship ALL records in each sync. works for medium sized tables, not suitable for large tables - allow me to add timestamp column to the source tables I have assumed the replication is in one direction only, and that the target tables can be wiped and matched to the source. If the target database is modified (e.g. demo website), you will lose changes in the next sync. The complexity can also increase if you have triggers and or foreign keys between tables - for the purpose of setting up the sync, I will drop them from the target since referential integrity is managed at the source. Regards, Richard

Hi, We are experienced programmer with more than 4 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. We are also having experience in developing of mobile Apps in Native & Phone GAP technologies. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Regards, JayamSoft

Seasoned programmer with more than 6 years exp using .Net framework. Accustomed to client side JS, AngularJS, KnockoutJS, NodeJs, Dynamics CRM, SQL Server, MySql, Swift, BootStrap. Would definitely like to see your company work and start collaborating. I have worked in several big profile projects for some of the biggest investments firms, and financial analysis companies in the US (LPL, DTCC, Delta Data, just to name a few) This is right up my alley. I'm fast and reliable. I do freelancing for several companies, just starting to create Freelancer.com potfolio.

Hi, I propose to create a windows service. I envision it working as follows: On the main database, we have a table, maybe called changes. This table will be written to by triggers any time the source tables are changed and will also have a timestamp of the changes. The service will check this table for any changes and then implement them in the backup tables. At the end of a service loop, it will store the latest time and then then next time it will start from only the new records. I have implemented such a system successfully for a client on Freelancer where they needed to sync an SQL database with a Google calendar. Best Regards, Anthony.

I can help with this replication request.I am a Microsoft Certified Solutions Master: SQL Server. I am a SQL Server Consultant working as a Developer and DBA, I have had 14 years experience (SQL Server 2005 - 2014). I have my own website http://www.nicholsonsql.com. I have experience with many companies large (particularly large government departments with 100,000+ users). If you have any questions let me know.

A proposal has not yet been provided

A proposal has not yet been provided

Hi, My name is Au. I have been working with SQL server more than 5 years and C# is programming language that I am using daily to develop software. I wish have chance to work with you for this task. It is really very exciting. Thank you so much for your consideration me. Best Regards, Au

A proposal has not yet been provided

===Payment After Successfully Deliverabl=== Estimated Time: 16 hrs. I have gone through your requirement & detailed job description. I possess a great expertise in delivering the project with strong professionalism. I understand that you are looking Database Developer and Administrator for transactional sync and update between two database. I can assure you that i can make transactional update between two database l because I have 12 + years of experience in database development and administration and handling more than 32 GB of databases. Hence i assure you that I am capable of doing this work. Please connect me once I assure you that I will try to finalize everything as per your expectation. I really appreciate your unavoidable attention on my proposal, I look forward to hear from you soon.