I'm very new to database "stuff" so this is the best place I know to ask this (boy does that sound negative! ;-)).
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.
Here's the deal:
I'm working with 2 databases. They are seperated for security reasons.
One is on a private intranet database. It's constantly changing.
The other is online and part of a website where people can see what's happening.
The problem is that I need to synchronize the online database every x minutes and I have no idea how to do this :-(
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)?
Should I just check EVERY item in it with a hash of the data that was in it last time?
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 ;-)
Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
Want more info? How to link or
or How to display code and escape characters
are good places to start.