Hope this is the right group to ask this question. If not, I apologize in advance.
We have developed a client/server application with VB.net utilizing mysql 5.1. We have multiple customers, each with their own database server. Peridically, we update our
primary database with new content and need to update each customer database with the new info. My question is this:
How can I select specific rows from certain tables in our primary database and "Insert" those new rows into the tables on a customers database on a different server? I can copy
rows now on localhost from one database to another ("Insert into db2.table Select * from db1.table where db1.table.colum = value) , but don't have a clue as how to connect to a
different host to do the insert.
I would like to automate this as much as possible using vb.net and connector.net. Any help would be greatly appreciated!!
TIA!
Daniel
--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -
We have developed a client/server application with VB.net utilizing mysql 5.1. We have multiple customers, each with their own database server. Peridically, we update our
primary database with new content and need to update each customer database with the new info. My question is this:
How can I select specific rows from certain tables in our primary database and "Insert" those new rows into the tables on a customers database on a different server? I can copy
rows now on localhost from one database to another ("Insert into db2.table Select * from db1.table where db1.table.colum = value) , but don't have a clue as how to connect to a
different host to do the insert.
I would like to automate this as much as possible using vb.net and connector.net. Any help would be greatly appreciated!!
TIA!
Daniel
--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -
Comment