I posted this originally in the incorrect forum I believe so I am reposting this in here which I believe is the proper place.
I need to move essentially a flat file from one server to another one and export it into a database on the second server. Does anyone have an easy process to accomplish this? I am currently at a loss. Any advice would be much appreciated.
Say I need to have a sql server just listen for updates that are made in a web server. Currently these two are on seperate boxes but I need to have data passed only from the web server to the sql server. Using the load command is there a simple way to have the sql server continually listening for updates while keeping security high and preventing any possible accidents to the sql database.
Web server takes input, the sql server listens for updates to the web server and when updates take place the sql server imports the data for storage and review at later dates.
Does that make sense?
Would setting up a virtual drive as a holding area and then just pointing the sql database be a good option for this?
Originally posted by Brett Kaiser
How would SQL Server "see" The Web Changes?
Where is the Web Data stored? And why is it not stored in SQL Server in the first place? Doesn't the app talk to the database?
The web server and database server are linked using a ODBC connection. What happens is that the data when inputed on the web server is being saved to the web server just not being send to the database server. Can the Load Data Infile command be used to import data to the databse server from the web server with an ODBC connection? I am not having much luck finding that information on the net.