Page 1 of 1

Moving Data Between Servers

Posted: Sat Jan 20, 2007 10:51 am
by WanamakerStudios
I have one central server that I receive a database feed on. I also have a secondary server that I would like to export some of that data to. How can I create a statement that would select certain records from one DB on one host and insert it into another DB on a different host?

Posted: Sat Jan 20, 2007 11:52 am
by feyd
Either set up replication, or create an intermediary that connects to both servers transferring data as needed.