Export tables to another DB

[samonwalkabout]

I have an established database running on a server. But i need to web publish some querys from the database. Im going to use coldfusion but need the Backend Db to be on the web server for this to work with the set-up here.

I dont want to move the location of the Db for speed reasons.

I propse to create a copy of the database on the web server and update its tables with data changed in the live version. Is there some way that i can update the records in the "copy" of the backend on the webserver.

I know i can import data into a database ect but i want to update the data to the web server location DB without opening it directly.

I guess im looking for a import to command, or someway of scheduling the webserver DB to run a set of updates at a certain time

Thanks

 

[samonwalkabout]

any help with this would be great guys