Re: [FWD: Preprocessor for writing .SQL files for Oracle PLSQL and MS TSQL]

2013-01-29 Thread John SJ Anderson
On Tue, Jan 29, 2013 at 10:42 AM, wrote: > Hmmm OK, I forgot to mention the stored procedures in addition to the > DML and DDL. It looks like these DBIx::Class::Schema will for for DDL only. > Will they work for DML and stored procedures too? To the extent that what you mean by 'DML' is real

Re: [FWD: Preprocessor for writing .SQL files for Oracle PLSQL and MS TSQL]

2013-01-29 Thread John SJ Anderson
On Tue, Jan 29, 2013 at 7:44 AM, wrote: > Anyone have any suggestions to make it easier? > Can anyone help me get started? How about expressing your schema as a DBIx::Class::Schema[1] and then using DBIx::Class::Schema::Loader[2] to dump the different DDL dialects that you need? 1: https://met

[FWD: Preprocessor for writing .SQL files for Oracle PLSQL and MS TSQL]

2013-01-29 Thread siegfried
I'm trying to write some data definition code (DDL) and data manipulation (DML) SQL code and I want a single source code file for both Oracle PL/SQL and Microsoft's TSQL. Does anyone know of a pre-processor that would accept a source file like this -- begin file xyz.sql #if PLSQL #elseif TSQL