I have to migrate from MS SQL Server and now creating a new ORACLE database with the data partially got from my old tables.
For that I need to get the data from dozens of tables as unicode CSV or TXT files, with fields separated by "|".
The bad thing is the default export master of MS SQL Server can export only single table at a time, and it takes a considerable time to configure export options for each table. I started to export them manually but I got an attack of nerves at the 10th table.
Do you know the way how to export ALL the tables into csv or txt from SQL server?