Data Synchronization between Microsoft Exchange and SQL server
$750-1500 CAD
Cerrado
Publicado hace más de 10 años
$750-1500 CAD
Pagado a la entrega
Project Description: \r\nI am looking to kick start a project where one of the requirements is to synchronize all the email message and folders to/from Exchange Server 2013 to SQL Server 2012,develop a software as a service, so the client application can easily use this service to sync the data between exchange server and SQL server and retrieve the specific message and folder.\r\n\r\nRequirements\r\n- Needs to be developed in C# .NET 4.0 or later.\r\n- Would need to work with multiple Exchange mailboxes.\r\n- Needs to work with Exchange 2010 or greater.\r\n- Only sync the changed data in exchange server into sql server.\r\n- Needs to develop a windows service (or web service) to read and maintain a record of all e-mail messages etc. that are sent, received and stored in exchange\r\n a. Store info in an SQL database that has a table for folders, a table for messages and a table that relates messages to folders\r\n b. Store entryid, messageid, storied and other related metadata from each folder/message\r\n- Client software calls a function in the service to \"RetrieveMessage\'. The parameters for the message is something like the Mailbox server, \'StoreID\' and \'EntryID\' in exchange.\r\n- The service responds by retrieving the requested message from exchange and passing the message to client software via streaming or by dropping it on a share and passing back the path information to the file.\r\n- The format of the message should be MSG FORMAT using the same internal format (HTML, plain text, rich text) as the message was originally sent in.\r\n\r\n\r\nPotential solution:\r\n1--- Would use EWS (Exchange Web Services) Managed API v2.0 ([login to view URL](v=exchg.80).aspx) to access the Exchange layer and determine the synchronization state.2\r\n\r\n2---You can use use SQL Server Change Tracking to determine changes in the table. ([login to view URL]) but if you have your own sync engine I would consider that as well.\r\n\r\n3--Implement all of this using the Microsoft Sync Framework ([login to view URL])\r\n\r\n\r\nEnd result\r\n- Clear and concise C# code samples using design patterns as necessary to demo the result of the data synchronization.\r\n- Data conflict resolution should be configurable in code.\r\n- No front-end is needed, should be running as a service\r\n\r\n\r\nWe can provide servers for testing/development.
Hello ,we have gone through your project named Data Synchronization between Microsoft Exchange and SQL server and we like to convey that we have already done similar kind of projects before also. We can address any concerns that you might have in regards to moving forward with the project. Regards Krish.
Hi there, I'm an experienced Software Engineer with more than 6 years in the software development industry, working for world-renowned companies. I've done a similar job recently where I was given access to the development/testing environment and servers, and I have excellent reviews from that job. You can have a look at my profile for further details. Thanks.
Hi gramball, I have gone through the project details. I have very good experience in data synchronization. Its one of my regular work. Hope to hear from you and looking for long term relationship
I quoted you 30 days as it will not take that long but do to you having live feed communication we will need a week or two cushion for testing as I am yet to see a project like this magically work from the first try.
I am American, I speak native English I am available for a project like this as I have cleared and delivered my previous project so my full undivided attention will be focused on this project. You will notice I quoted you higher not because I am greedy but rather because I really want to ensure I can deliver on time and quality but still keeping within a proper budget as I always guarantee 100% satisfaction. I am a registered company so I can get sued I have to make sure the job can and will get done.
Thank you.
Hi,
We've prior experience working with different servers and synchronizing the data between them. Microsoft technologies are our forte. We'll create a windows service which will run as a Back-end process and keep the databases in sync using the sync framework and change tracking system of SQL server.
We'll require a development server, with similar configuration as you've on production server. The complete solution will be configurable and you'll be able to access configurations through desktop admin panel. The log file will be created for each conflict and the resolution or decision that application makes.
There are a few queries which we'd like to get answers before getting into detailed plan and execution of the project.
I'd like to request you to come online on any IM, skype preferred, to discuss more about it. The initial call/meeting will be less than 30 minutes. Looking forward to hear from you.
Regards,
Kawal Babra