Exporting from local to remote server.

[manishsawant]

Hi,

I want a functionality like database replication. I am using SQL Server 2000 and i have 2 differect applications. One is a Lan application and the other one is the Web application. Likewise i have 2 different databases one for Lan and one for web(Remote). But the data structure is the same for both the database. When ever i insert update or delete i want it to be updated on my web server database. All inserts updates or delete will be done in the Lan Application. I dont want the data transfer to happen immidiately as i dont have the infrastructure to apply direct replication.

I want to give a funtionality which will allow the Admin user of the lan application to transfer the updated data to the web server. Is there any possibility to do this.

I have thought of creating a web service and pass a dataset to the web service and the web service transfers the data. But how will i recognise the changed data. How will i keep this entire thing in one transaction.

Can Sql Server give me anything that will allow me to use it in my code and export the data on my remote server.

Please suggest.

Thanks,
Manish