[no subject]

> I am looking at a project that will involve migration of a MySql
> database to PostgreSQL. The original db has numerous design errors that
> are beginning to cause problems. The move to PostgreSQL will add the
> transaction capabilities that would have prevented the current problem
> causing the project (seqential transaction ID's would have been a great
> start!)

you can get transactions in mysql w/o migrating to PostgreSQL - check 
the InnoDB stuff....
 
> As this will need to be a parallel pair of db's for a while to run final
> tests, I'm looking at pitfalls and processes others have used to migrate
> from one 24x7 db to another seamlessly. I'm also looking for pointers on
> getting identical data simultaneously into two seperate db's without
> having to rewrite the entire app first.=20

sqlrelay &lt;<a  rel="nofollow" href="http://sqlrelay.sourceforge.net/";>http://sqlrelay.sourceforge.net/</a>&gt; might be usable for the 
write mirroring across 2 different dbs? I think the author may even be on 
this list

later,
chris


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00283" href="msg00283.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> tcarter at entrusion.com (Tony Carter)</li></ul></li>
<li><strong><a name="00343" href="msg00343.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00253" href="msg00253.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00261.html">[ale] Stupid NLD / Redcarpet question</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00263.html">[ale] database conversion</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00281.html">[ale] database conversion</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00283.html">[ale] database conversion</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00262"><strong>Date</strong></a></li>
<li><a href="threads.html#00262"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>