I must create SQL script with test data.
I must look for a tool/mechanism to:
- specify dataset only one time
- get it load data to MySQL and Oracle
- it may create native SQL or simply perform card inserts, I do not care
Can everyone recommend good tool for your?
From things i get, I'd recommand you to definitely write the exam datas within an XML/CSV file and make ETL Batch to load your database.
Have a look at Kettle, free and simple to use.
Hope I possibly could help,
you could also take a look at Oracle's SQL Developer product - free and may connect with both DBs and load and export data and do SQL. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html *There's additionally a free data modeler for modeling (and reverse engineering ) databases.