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.