473,320 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to connect two databases on two hosts?

344 100+
Hello,

How can I connect two databases on two different host? I'm trying to copy some data from a table#1-database#1 to table#1-database#2.

Thanks in advanced!
Mar 2 '11 #1
2 1968
dgreenhouse
250 Expert 100+
Assuming that this is a "one off" task, the simplest way is to create an export of a query (using phpmyadmin) from the source host/table, transfer it to the host/target, and then import into the target/table.

There are a number of other ways, but IMHO this is the simplest.
Mar 3 '11 #2
Bassem
344 100+
Thanks a lot dgreenhouse for your help!

I'm trying to create a program to do the copying on a condition for more than one time where the source is updated every while.

In more details:
1. There is database#1 has table#1 where data is inserted every moment.
2. There is database#2 has table#2.
3. I wan to copy some fields from db#1 tbl#1 to db#2 tbl#1. Not only for one time but will do again for the new data that inserted every while.
4. I'm doing that using C#.

I'm thinking, I will copy the data to the application using a connection then insert these data to the second database through a second connection. Is there a more simple solution where I can connect directly the two databases?

Thanks,
Bassem
Mar 3 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: jtd | last post by:
Hi all, I'm using asyncore to download a large list of web pages, and I've noticed dispatcher.connect blocks for some hosts. I was under the impression that non-blocking sockets do not block on...
33
by: Savas Ates | last post by:
in asp page im getting this error how can i solve it.. yesterday the codes work but i setup visual studio 6.0 now it doesnt works..
1
by: puppet_sock | last post by:
I guess this is an architecture question. The question is: If I've got two (or more) Oracle databases, when does it make sense to integrate them into a single database, and when should they be...
4
by: Ellen K. | last post by:
Hi all, Being that so far I didn't get an answer to my below problem on the Oracle newsgroup, I figured it couldn't hurt to try here. While at my current job I've been working with mostly SQL...
0
by: David Swanson | last post by:
I am trying to configure the proxy section of the machine.config to handle BOTH connecting to hosts that are not "live" but rather defined in my winnt/system32/drivers/etc/hosts file. AND to hosts...
7
by: bill.brennum | last post by:
Hi, Have a number of Access Databases that I inherited and want to zip a few of them. My concern is that other active Microsoft Applications may be linking to the database or its tables. Is...
10
by: Br | last post by:
We have a product that is being used by a client to outsource salary packaging. They therefore run several instances of our database, one for each of their clients. There is now a requirement to...
5
by: Odd Bjørn Andersen | last post by:
I have installed DB2 9 Enterprise Edition on my laptop and created the sample database. Now I'm having truble connecting to the database from Command Editor. If I connect from Command Window it's...
10
by: blurryimage | last post by:
Ok guys I have racked my brain on this one. I have a vb .net service installed on a win2k server. I am trying to get it to connect to sql 2000 box but I get this error: An error has occurred...
3
by: byrocat | last post by:
Up until now, I've been working with V& DB2 UDB databases, using Embarcadero DBArtisan as my GUI tool. I also have other tools that I use in my day-to-day job so running directly on the server via...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.