On Thu, 13 Oct 2011 23:20:24 +0200, Raphael Vullriede <[email protected]> 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
