in reply to psql splitter for php
In this situation I would produce SQL statement files. I would have these files duplicated and ordered by execution order. I would then have an agent based system for each database where the updates to the database are made in order for each copy of the SQL files for each of the database versions. There are some situation where this will not work, depending of the SQL logic. In most cases it would work. Do you have knowledge of what SQL you would need to perform?
|