I have interesting migration issue where should help a lot if ADS could do:
1) export selected tables name do separate xls files, named by table name (example: persons.xls)
2) every file's first row contains atribut name + datatype + nullable + PK/FK (example: name[VARCHAR2(20) NOT NULL]; surname[VARCHAR2(20) NOT NULL]; personId[NUMBER(10,0) NOT NULL PK])...
Has ADS some export like this?
Hello,There are a couple options that Aqua Data Studio has to export data and ddl. 1) Schema Script Generator will generate the ddl and insert statements for the data. You can read about that here https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.5/page/83/Generate-SQL-Scripts2) Data Export Tool will generate xlsx data, csv data or insert statements. You can read about it herehttps://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.5/page/210/How-to-Export-Data3) Database Schema and Data Exporter project. This tool generates an aquascript template that can be executed to extract both ddl and csv or xlxs data. You can read about it here. https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.5/page/AquaScript-Templates/AquaScript-Templates#Template_2You are probably looking for something like #3Attached are some screenshots... Let me know if you have more questions.Hope that helps,Tom
Powered by IDERA