ASP.NET WebService for SQL Script Synchronization
$30-100 USD
Pagado a la entrega
Hello,
I have an ASP.NET website which runs on MS SQL Server 2005. I have a local version of that database as MS SQL Server Express 2005. I have an Windows Application where I want to implement such functionality so that My Windows application (C#.NET 2.0) can communicate with an remote ASP.NET (2.0 - C#) web service and using that webservice, my Windows Application will be able to download all the avalable data structure and data from the SQL server (may be as SQL Script or any other way) and update my local version of SQL Server Express 2005. Also my Windows application should be able to update back the remote SQL Server based on the local SQL Express database data.
So, basically as a coder, you need to develop the ASP.NET (2.0 - C#) Web Service. I will expect an demo Windows application from you where you will have at least 2 buttons, one for download to local SQL express from remote SQL Server 2005., another for upload from local SQL Express to remote SQL server 2005. Please note, upload and download means, completely data structure and data.
I need to synchronize only Tables, not SP, Views, Rules, XML Schema, jobs, UDT etc... so, the work is very simple and straight forward.
I would like to clarify the requirement as follows:
===================================================
1] Web Service part which will get the required information to supply to the calling Widows application when a connection string is provided to the Web Method as argument. Also it will also update the SQL Server 2005 database based on the request made by remote Windows Application (update back).
2] Windows Application part : windows application will request the ASP.NET Web application to get the whole data structure and data and then Windows application will point to a SQL Express MDF file (given by user) and update that MDF file. Also Windows Application will get the data structure and data from a given MDF file and call that ASP.NET Web service to synchronize/update based on that MDF file.
Nº del proyecto: #192394
Sobre el proyecto
15 freelancers están ofertando un promedio de $97 por este trabajo
I can do this for you using C# or VB.Net (1.1 or 2.0) with any database and you will see my work.
I will provide you the service which will get the database changes with all of the structure change and data modification. The webservice will be written in .Net 2.0/3.0 and one samle demo will also be provided with Más
Hi there, I already implements an application like this using off line application block and microsoft data access. Please check my profile and give me the detail requirement you need. Thanks.