Q:

Is there a way to export a sql server database from a windows form app to a web app in visual studio?

i'm working on a vb application that uses a sql server database in a desktop module(windows form) which is supposed to export this database to a web application(in vb.net).
so my question is : is there a way i can export this database from my desktop app to the web app and vice versa(from the web abck to the desktop app)
thnx in advance 

A:

Most Database servers have the possibility to Replicate their Database even over the Internet. That would be the simplest solution and you can find some very good articles. If you have differnet Databases types, this can be tricky or even impossible.
Second possibility: make a database dump, ftp the dump to your server, and the a program imports that dump. You must read if the "Web database" cann import that dump
Otherwise you have to have a server component that can Receive Data from your windos app and save that in the "Web Database".
Your windws Program is the client who opens a connection to the web app, opens the dDatabse and sends the database, for example as sql statement text to the wep app.
The cpnnection should be encrypted, and your wep app as server also shold include a login procedure, with very good passwort. You know that every Ip gets scanned permanently.
for such client server combination, you will find also lots of examples.
Good luck

