Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a large number of tables that I want to generate Load script for as opposed to manually writing the script for each table. I have retrieved the table names and column names from SQL as illustrated below:
I would like to generate a script file that looks like:
AccountCombos:
Load PK,
... REMAINING COLUMNS ... ;
SELECT SQL
... COLUMN LIST ;
From AccountCombos;
Store AccountCombos into ../qvd/AccountCombox.qvd(qvd);
drop table accountCombos;
For SQL Server there's an extractor .qvw app available. It shouldn't be too hard to adapt it for other sql databases. Especially if you already have the schema data available.