how to import and export data between local and remote server
843838Nov 29 2005 — edited Dec 12 2005Hi all,
right now i am in to my academic project, an intranet application using JSP & PostgreSQL. the work is for a univerity department. i hav provided all the internal management screens as an offline component. so all the pages wil reside in a local web server (Tomcat 5.5). but this department already have a web site. so i wud like my application to communicate with this web site. for example, the offline componenet can process the mark list details locally (no net connection needed for
that). and at the end of processing say let all the data be n "marklist_tbl" in the local database.
how could i provide an interface for the user to do an export operation (offcourse internet connection needed for that) by which this local "marklist_tbl" wil be copied to "marklist_tbl" on the remote web server(the remote server also has postgresql support, and i hav already created "marklist_tbl" table in the remote server). so what i need is a line by line copying of "marklist_tbl". so how can this be accomplished using JSP & Java. i cant use the import export screens provided by Postgresql, so the user feels that they r doing something by moving out of my application. similarly i wanna copy some tables in the remote server to the local database, say an import from remote server to my local machine.
i have the enitire privilages and paaswords (FTP, DB etc) with the web site and local server.
hope u became nutt with my lengthy mail. as i am totally new to Java, plz tell me whether this kind of an application (internet & intranet communication) has any technical issues? if not how can i do that.
drop in ur comments
thanks for ur time
regards
aleena