Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
We have two application one is desktop application and second is web application with Sql server 2005 database. Desktop application is using for data entry purpose and web application using for online reporting purpose. how to transfer all table data from one sql server to second sql server by checking duplicate data on web server database and by checking table relation also.
We want to transfer data in every 2 hours interval without stop desktop application and fast data transfer.
Currently we implemented a windows service, and we are using bulk insert.
but we having problem in it. We can not apply transaction on it. and at the time of power fail or restart the system We can't rollback and by the unique key on web server database we need to remove extra rows from the table.
We have minimum resources and slow internet speed.
Please give me a best solution for it.

With regards
Manoj
Posted
Updated 16-Jan-12 21:50pm
v3

1 solution

Hello Friend...

One Suggestion for your solution...

As you say that you use sql server database + windows application for data entry purpose...

and second sqlserver database + web application to show report online...

so it is not good idea to use this...

simply use only one database and use it with both windows app and web app so you not need to fire any cross database query and also the live data will used for reporting in web app....

so i think this will solve your both issue....

use a conman central server database idea for all web and desktop app it will faster and also provide proper reports to user with latest data...
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900