MsSqlToPostgres 4.3 Released
Download
2022/05/26
V4.3 Released
Merged to DBCopier.
2022/03/11
V4.2 Released
Fix parse date format in file when creating table.
Fix write bad file.
Improve display progress for estimated rows.
Improve insert/update to SQL Server.
2022/02/02
V4.1 Released
Improve create batch file for running scheduled task on Windows.
2021/12/30
V4.0 Released
Add "SSH tunnel connect" to Postgres.
Add suport Linux.
Add suport macOS.
Fix "create table".
Improve converting performance.
2021/07/28
V3.0 Released
Fix bugs caused by incompatible library version.
Improve create table.
2021/03/19
V2.9 Released
Add support to PostgreSQL 13.
Improve LOB read/write performance.
Improve importing performance.
2021/02/24
V2.8 Released
Add "run a task every n hours".
Add "run a task every n minutes".
2021/01/05
V2.7 Released
Add "Save To SQL File".
Fix view target table data on transfer tables.
Improve data convert performance.
2020/11/01
V2.6 Released
Add support to SQL Server 2019.
Fix adjust table list width.
Fix bug in batch transfering data from tables when target table name not same as source table name.
2020/04/15
V2.5 Released
Add support PostgreSQL 12.
Improve import part rows and skip rows.
Improve map columns.
2019/07/19
V2.4 Released
Improve importing performance.
Some other bug fixes and enhancements.
2018/08/02
V2.3 Released
Add convert "Struct Only".
Fix write empty string to CLOB/TEXT field.
Improve convert with large column count.
2018/03/19
V2.2 Released
Add "upsert" mode import.
Improve "update" mode import, update key must be unique index.
Improve performance by build index after convert.
2017/12/01
V2.1 Released
Fix Postgres schema contains upper case letter.
Fix import string contains single quote.
Fix load data to ftVarBytes field.
2017/06/14
V2.0 Released
Add "transfer N tables data to 1 table".
Add handle for skip rows big than total rows.
Add support date format like: "20150101 13:43:29".
Add support date format like: "2016-04-12T18:37:09-07:00".
Add support date format like: "2016-07-21T17:18:52Z".
Add support date format like: "Fri, 21 Oct 2016 13:08:32 +0800".
Add support date formats like: "2015:06:21", "2015:06:21 08:02:48", "2016:03:20 20:08:08-06:00".
Add view TEXT(CLOB) by mouse click.
Add view target table after importing.
2016/11/12
V1.9 Released
Add "Show table DDL".
Fix convert data from view.
Fix export query results that can not count records.
Improve convert combine primary key.
Improve wizard form UI.
2016/08/22
V1.8 Released
Add "Create Table" on right click menu.
Add "Database Object TreeView".
Add "Drop Table" on right click menu.
Add "View Table Data" on right click menu.
Add "View Table Struct" on right click menu.
2016/07/20
V1.7 Released
Add "Set default value for field" on creating table.
Add support converting index, primary key, and default value on creating tables.
Add support importing data to field that field name contains "~".
Adjust login form.
Fix data type "double precision" on creating table.
Fix get current schema.
Improve command line, made it more simple.
Improve converting data type on creating table.
2016/03/14
V1.6 Released
Add support importing data to field that field name contains "&".
Fix bug that caused by break line in sql query.
Improve auto create table contains GUID field.
Improve support to importing empty string data to not null field.
2015/07/20
V1.5 Released
Add auto parsing datetime format when create new table in batch convert.
Add support to field contains "<" or ">".
Add support to field contains line break.
Fix bug at click config button on batch converting tables.
Fix bug at converting data to created table that source table name contains special characters.
Fix bug at create table when batch converting tables to no-default schema.
Fix bug caused by PostgreSQL transaction.
Fix bug on edit data in resultset grid.
Improve execute in command line, will close if can not login database.
Improve support for more datetime format.
Improve support for more large integer field.
2015/03/27
V1.4 Released
Add "Show scheduled tasks".
Add adjust client encoding same to server encoding.
Add notify when load multiple data to one field at same time.
Add support create table on non-default schema.
Add support to Netherland number(currency) format like "96.325,75-".
Add support to date format like "22.12.2005." and "25.7.2008. 21:15:05" .
Fix bug on changing target schema.
Improve convert performance significantly.
2015/01/26
V1.3 Released
Add "Create bad file for failed convert records".
Add command-line and schedule task support to "save to sql".
Add notify when can not create log file.
Add support case-insensitive to table and field name.
Disable exception window when run in command-line.
Fix bug about can not close form when exception raise.
Fix bug on "change schema in importing tables to tables".
Imporve "Create Table" on "Import All Tables", auto fix table name on creating.
Imporve "Create Table", auto fix table/field name before create.
Imporve datetime convert support.
Imporve notify when can not create session file.
Improve support for create table from query.
2014/11/07
V1.2 Released
Improve "create target table", target table name auto change to created table.
Change reg code to license file.
Fix bug "create tables error" on "Import data from tables to tables".
Improve save session file, auto add folder and ext.
Improve exception report.
2014/08/13
V1.1 Released
Add "turning off log" in command line.
Fix bug "failed load part columns data in command line".
Fix bug when logon to SQL Server name with "\".
2013/11/15
V1.0 Released.
First Release.