Syncronizing Database on two Machines through USB or Serial

[gtmits]

I want two machines running windows 2003 and SQL 2000 to have their databases sync'd through a USB or Serial connection.

Is this possible? is there software to do this? any insight will help me.

thanks

 

[tman24m]

uh....huh huh.

A hub is less than $20, why would you even consider USB or serial

 

[gtmits]

I work in a company that has two serperate networks, the owner does not way the internet network to be anywhere near the inside network.

So in order to do some web based apps, i need to find out how to tranferr databases through a different connection, there no way around this, he will not put these networks together.

So if i want a database on two computers to be the same, how can i do this without using a network card? (without doing it manually)

Thanks

 

[theoxyde]

Even so, a couple of Gigabit network cards, a crossover cable, and some statically assigned private IPs would be better. This new "network" is completely isolated from everything else just like it would be if you were using USB, only a lot faster and more "standard" as there is no extra software installed.

The end result is identical, you are just using an ethernet cable instead of a USB cable. I have a client site set up like this. Their regular network is a non-switched 10/100 network, but the web server talks to the database server over a dedicated GigE connection via a crossover cable. The regular network is a 192.168.0.xxx address range and the two GigE cards have 10.1.1.xxx addresses. I adjusted the hosts file so they will always chatter to each other over the private connection rather than the regular network.

It runs transparently and is isolated from the rest of the network.

 

[gtmits]

hey theoxyde, is there anyway you can email me some good reading material on the way your doing it? or some kinda of walk through of something on how your doing that? and from there im assuming that i just set up SQL replication to keep the databases sync'd?

Thanks
My email is ric@silverwoodthemepark.com