On Thu, 13 Oct 2011 23:20:24 +0200, Raphael Vullriede <lists.raphael@vullriede.de> wrote:
we have a lot of developers writing a lot of SQL scripts against a lot of different databases. These scripts usually consists of mixed DDL (e.g. change a column definition) and DML (e.g. adding new master data). Since our applications are constantly under development we'd like to add these scripts to our continuous integration environment. For that it would be great to have a feature that checks the script against a given database without actually executing it. It should not only check the SQL syntax but also if all mentioned tables, columns etc. exists in the given database.
This (of course) won't always work. ALTER TABLE ADD COLUMN and then mention that column. As an alternative, maybe start up a local server and load data in it to test the scripts on. -- Stewart Smith