Withdata software has announced xlstopg 1.0, a data conversion tool that import Excel data to PostgreSQL database. XlsToPG 1.0 is the first release version. XlsToPG – A better tool for importing Excel data to PostgreSQL XlsToPG is convenient: 1. Easy visually config, just click on the ... Read more
Withdata Software Released TxtToPG Version 1.0
Withdata software has announced txttopg 1.0, a data conversion tool that import csv(txt) data to PostgreSQL database. TxtToPG 1.0 is the first release version. TxtToPG – A Better Way to import CSV(TXT) data to PostgreSQL TxtToPG is convenient: 1. Easy visually config, just click on the ... Read more
Withdata Software Released Tail4win Version 4.6
WITHDATA SOFTWARE has announced Tail4win 4.6, a windows port of the UNIX ‘tail -f’ command. Tail4win 4.6 add global Highlight and Filter, and improve utf8 and unicode encoding support. Tail4win – Windows Tail. Tail4win is convenient: 1.Highlighting and filtering(as “tail ... Read more
Withdata Software Released TxtToSqlite Version 1.0
Withdata software has announced txttosqlite 1.0, a data conversion tool that import csv(txt) data to SQLite database. TxtToSqlite 1.0 is the first release version. TxtToSqlite – A Better Way to import CSV(TXT) data to Sqlite TxtToSqlite is convenient: 1. Easy visually config, just click on ... Read more
How to execute sql file via command line for PostgreSQL
Use psql psql -U username -d myDataBase -a -f myInsertFile More information: http://blog.manoharbhattarai.com.np/2013/04/03/execute-sql-file-from-command-line-in-postgresql/ ... Read more
How to execute sql file via command line for Oracle
Use sql*plus run SQL file sqlplus username/password@databasename @/path/to/test.sql If you want to see whats going on like this, including any error messages, you need connect to SQL*Plus with sqlplus username/password@databasename Then run the script from the SQL*Plus prompt: set echo ... Read more
How to execute sql file via command line for DB2
You can save a .sql file to your hard drive, and execute it using the DB2 command line using: db2 -vtf C:\path\to\test.sql -v echoes the command text back to the command line -t sets the statement terminator to ;. -f tells the command line to load the commands from the file. See other command ... Read more
How to execute sql file at SQL Server command line
You can use sqlcmd to run a Transact-SQL script file. A Transact-SQL script file is a text file that can contain a combination of Transact-SQL statements, sqlcmdcommands, and scripting variables. To run the script file 1.Open a command prompt window. 2.In the Command Prompt window, ... Read more
How to execute sql file at MySQL command line
If you’re at the MySQL command line mysql> you can declare the SQL file as source, like: mysql> source 'path/to/test.sql'; Or use the MySQL command line client: mysql -hhostname -uuser database < path/to/test.sql ... Read more
Withdata Software Released OraLobEditor 3.6
Withdata software has announced oralobeditor 3.6, a tool that helps you edit Oracle lob(clob,blob) data directly. OraLobEditor 3.6 add “Task Schedule”, improve import/export performance, and fix “division by zero” bug in importing/exporting process. OraLobEditor – ... Read more