perlquestion
$CBAS
<P>Hi,
<P>I'm very new to database "stuff" so this is the best place I know to ask this (boy does that sound negative! ;-)).
<BR>Right now I'm figuring out the basics with mySQL but I will probably have to use a non-open source DB when this project takes off ... I just hope that doesn't mean I'll have to start learning all over again.
<P>Here's the deal:
<BR>I'm working with 2 databases. They are seperated for security reasons.
<BR>One is on a private intranet database. It's constantly changing.
<BR>The other is online and part of a website where people can see what's happening.
<P>The problem is that I need to synchronize the online database every x minutes and I have no idea how to do this :-(
<P>Are there any tricks (Perl or SQL) to get the changed parts of a database so I don't need to copy the whole thing (which would be impossible)?
<BR>Should I just check EVERY item in it with a hash of the data that was in it last time?
<P>Any links to good database information sites are appreciated because I'm just getting into it and I like to learn as much as possible, as fast as possible ;-)
<P>thanks!
<BR>CBAS