Roeland
Member³
By using "Compare Table Data" a lot now, may I ask for these 2 extra features?
I prefer to store my scripts for updating databases.
1) Try to convert CLOB columns to string by using to_char(). This way we can still use "generate script" instead of "update database". I know this may fail sometimes, but these records must then be processed separately.
2) Could you add a feature to remove tables from the list if using "update database" and there are no lob columns in the table. I want to use "update database" ONLY when dealing with BLOB's or large CLOB's
Thanks,
Roeland
I prefer to store my scripts for updating databases.
1) Try to convert CLOB columns to string by using to_char(). This way we can still use "generate script" instead of "update database". I know this may fail sometimes, but these records must then be processed separately.
2) Could you add a feature to remove tables from the list if using "update database" and there are no lob columns in the table. I want to use "update database" ONLY when dealing with BLOB's or large CLOB's
Thanks,
Roeland