Want to Store database locally and then update it to remote server
-
Hi, I am having web application and windows application. Now I want to store all database tables information(server database) into the cache. I don't want any local database to store servers database. I want to use cache. Just like replica of the servers database These information can be access by windows application program. after updating cache information these information can be update to again web servers database. How can I do? Is there any other solution so that I can use server database locally for some time , update some tables information to locally and the again update to servers database i.e. overwrite it to servers database only those which is updated locally. Thanks sjs4u
-
Hi, I am having web application and windows application. Now I want to store all database tables information(server database) into the cache. I don't want any local database to store servers database. I want to use cache. Just like replica of the servers database These information can be access by windows application program. after updating cache information these information can be update to again web servers database. How can I do? Is there any other solution so that I can use server database locally for some time , update some tables information to locally and the again update to servers database i.e. overwrite it to servers database only those which is updated locally. Thanks sjs4u
Do you want to cache information locally using your windows application or web application? You cannot cache replica of server database tables locally using web appliction. You can use SQL Server 2005 Express Edition if you want to do it using Windows application.
-
Do you want to cache information locally using your windows application or web application? You cannot cache replica of server database tables locally using web appliction. You can use SQL Server 2005 Express Edition if you want to do it using Windows application.
-
Thanks for the reply. Well I am using windows application for getting cache data. Update Cache data and then want to store that table on servers database which is updated locally. Thanks sjs4u
This question STILL has nothing to do with ASP.NET. You have a windows program, and I expect you will have a webservice which will upload it's data to a server. There's no ASP.NET involved here, even if there's an ASP.NET website on the other end of all this code. I would just write a webservice which takes data and runs it into the database, I wouldn't be passing a whole database through the web, I'd just do an update as needed.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.