Withdata software has announced sqltotxt 2.5, a data conversion tool that export SQL Server data to flat file (csv, xml, html, sql) and excel. SqlToTxt 2.5 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. SqlToTxt ... Read more
Withdata Software Released MyToTxt Version 2.2
Withdata software has announced mytotxt 2.2, a data conversion tool that export MySQL data to flat file (csv, xml, html, sql) and excel. MyToTxt 2.2 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. MyToTxt – The ... Read more
Withdata Software Released DB2ToTxt Version 2.0
Withdata software has announced db2totxt 2.0, a data conversion tool that export DB2 data to flat file (csv, xml, html, sql) and excel. DB2ToTxt 2.0 add “Task Schedule”, add support to XML type field, improve export performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released AccessToFile Version 2.3
Withdata software has announced accesstofile 2.3, a data conversion tool that export Access data to flat file (csv, xml, html, sql) and excel. AccessToFile 2.3 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing ... Read more
Replace Update or Insert a row Into PostgreSQL Table
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in PostgreSQL? A way to do an “UPSERT” in postgresql is to do two sequential ... Read more
Replace Update or Insert a row Into Sqlite Table
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in Sqlite? Use “INSERT OR REPLACE INTO” . For example: INSERT OR REPLACE INTO Employee ... Read more
Withdata Software Released OraLoader Version 4.4
Withdata software has announced oraloader 4.4, a data conversion tool that helps dba and database developer import/export Oracle database from/to flat files and Excel files. OraLoader 4.4 add “Task Schedule”, improve import performance, and fix “division by zero” bug in ... Read more
Withdata Software Released XlsToSql Version 2.4
Withdata software has announced xlstosql 2.4, a data conversion tool that import Excel data to ms SQL Server database. XlsToSql 2.4 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. XlsToSql – A Better way to import ... Read more
Withdata Software Released XlsToOra Version 2.9
Withdata software has announced xlstoora 2.9, a data conversion tool that import Excel data to Oracle database. XlsToOra 2.9 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. XlsToOra – A better way to import Excel ... Read more
Withdata Software Released XlsToMy Version 2.1
Withdata software has announced xlstomy 2.1, a data conversion tool that import Excel data to MySQL database. XlsToMy 2.1 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. XlsToMy – A better way to import Excel data ... Read more