Features SQL Server/SQL Azure/LocalDB/MySQL/Oracle/IBM DB2/Informix/PostgreSQL/
Vertica/NuoDB/Teradata/Sybase ASE/Firebird/SQLCe/SQLite/VistaDB 支持support + + + Access, Excel, dBase and Text 支持support
* Office Access or Access Database Engine 需被安裝needs to be installed. 32bit 32bit 64bit

If you are trying to install the same version of 64bit Access Database Engine and 32bit Microsoft Office, you will get an error messages:
"You cannot install the 64bit version of Microsoft Access Database Engine because you currently have 32bit products installed..."
But you can install the different version of Office and Access Database Engine to solve this issue.
For example:
Office 2013 32bit + Access Database Engine 2010 64bit
Office 2016 32bit + Access Database Engine 2010 64bit
Office 2013 64bit + Access Database Engine 2010 32bit
Office 2016 64bit + Access Database Engine 2010 32bit
Note: If you still got the error, you can use the "/passive" command line parameter to install it:
AccessDatabaseEngine[_x64].exe /passive

ODBC and OleDB 支持support
* ODBC or OleDB drivers 需被安裝need to be installed.(32bit for Free/Plus, 64bit for Standard/Professional) 32bit 32bit 64bit FoxPro 支持support + + - 無限制轉換次數Number of conversions Unlimited Unlimited Unlimited 每個資料表的資料列限制Rows Limit per table* 10,000 Unlimited Unlimited 批次轉換Batch conversion 2 Unlimited Unlimited 大量複製模式Bulk Copy mode
* Support for SQL Server/SQL Azure/NuoDB/IBM DB2/Informix/Oracle - + + 大量匯入模式Bulk Insert mode
* Support for SQL Server/SQL Azure/NuoDB/IBM DB2/SQLite/PostgreSQL/MySQL/Firebird/Oracle + + + 自動對應欄位資料類型Automatic Mapping Types + + + 自訂對應欄位資料類型Custom Mapping Types + + + 對應目的資料表欄位名稱Mapping column names from the target table + + + 自動建立資料表與索引Automatically create table and indexes + + + 儲存變更Saving Changes + + + 轉換結果瀏覽Showing target results + + + 新增/更名欄位Adding/Renaming columns + + + 轉換大小寫, 加入字首與字尾Converting case, adding prefix and suffix + + + SQL 語法預覽SQL preview + + + 索引管理Managing Indexes + + + 轉換 TABLE 與 INDEX 定義至任意資料庫類型Converting TABLE and INDEX definitions to any DB type + + + 在同資料庫類型下遷移 VIEW/PROCEDURE/FUNCTION/SEQUENCE/DOMAIN 定義Migrating VIEW/PROCEDURE/FUNCTION/SEQUENCE/DOMAIN definitions
* Support for the same DB type + + + 在同資料庫類型下遷移資料表 TRIGGER 定義Migrating TRIGGER definitions of tables
* Support for the same DB type + + + 自動生成資料表檢查條件約束Auto-generating CHECK constraints of tables + + + 自動生成資料表欄位預設值Auto-generating DEFAULT values of columns + + + 自動生成[資料表與欄位]的註解Auto-generating COMMENTS of tables and columns + + + 自動生成資料表外部索引鍵Auto-generating FOREIGN KEYS of tables
* All referenced tables are selected without rearranging the order + + + 同步資料Data Synchronization - + + 附加資料Appending Data - + + 支持命令列處理Command-Line support 
* 自動命令列生成Automatically generate the command-line - + +

• app.exe -?
• app.exe -srctype:dbtype -desttype:dbtype -src:profile -dest:profile -srcschema:schema -destschema:schema -srctable@desttable:table -mappingtypes:srctype@desttype -srcdbpwd:xxx -destdbpwd:xxx
• app.exe -srctype:9 -desttype:0 -src:"C:\sqlite.db" -dest:"C:\access.mdb" -srctable:* -tableonly
• app.exe -srctype:3 -desttype:0 -src:"C:\foxpro.{dbc|dbf}|*.dbf" -dest:"C:\access.mdb" -srctable:* -tableonly
• app.exe -srctype:9 -desttype:0 -src:"C:\sqlite.db" -srcdbpwd:xxx -dest:"C:\access.mdb" -destdbpwd:xxx -srctable:*
• app.exe -srctype:0 -desttype:9 -src:"C:\access.mdb" -dest:"C:\sqlite.db" -srctable:tableA -srcdbpwd:xxx -wrkgrp:"x:\WorkgroupFile\security.mdw" -u:userid -w:userpwd
• app.exe -srctype:9 -desttype:0 -src:"C:\sqlite.db" -dest:"C:\access.mdb" -srctable:tableA -defopt:sync
• app.exe -srctype:9 -desttype:0 -src:"C:\sqlite.db" -dest:"C:\access.mdb" -srctable:tableA -defopt:sync -skipdel
• app.exe -srctype:9 -desttype:0 -src:"C:\sqlite.db" -dest:"C:\access.mdb" -srctable:tableA,tableB
• app.exe -srctype:9 -desttype:0 -src:"C:\sqlite.db" -dest:"C:\access.mdb" -mappingtypes:ntext@varchar,float@long
• app.exe -srctype:9 -desttype:5 -src:"C:\sqlite.db" -dest:"profile_name" -destschema:"test" -srctable@desttable:tabA@new_tabA,tabB,tabC
• app.exe -srctype:9 -desttype:5 -src:"C:\sqlite.db" -dest:"profile_name" -destschema:"test" -srctable@desttable:tabA@new_tabA,tabB@new_tabB
• app.exe -srctype:5 -desttype:5 -src:"profile_name" -dest:"profile_name" -srcschema:"schemaA" -destschema:"schemaB" -srctable:*
• app.exe -srctype:6 -desttype:9 -src:"profile_name" -dest:"C:\sqlite.db" -srcschema:"srcdatabase" -srctable:schema.table
• app.exe -srctype:6 -desttype:9 -src:"profile_name" -dest:"C:\sqlite.db" -srcsql@desttable:"SQL statement...@new_tab"
• app.exe opensession.dms"
  (Optional)
  Default Confirmation Options (if the target table exists):
  • -defopt:rename
  • -defopt:recreate
  • -defopt:delete
  • -defopt:append
    • -keepauto (preserve source auto increment values, if exists.)
  • -defopt:sync
    • -skipnew (skip new rows)
    • -skipupd (skip updated rows)
    • -skipdel (skip deleted rows)
  Log mode, No window, Skipping errors (app.log):
  • -log
  Bulk Copy mode support for SQL Server, SQL Azure, IBM DB2, Informix, NuoDB and Oracle:
  • -bulkcopy
  Global table and column case:
  • -lowercase and -uppercase
  Excluding View Objects:
  • -tableonly
  Exit Code: Success=0, Failure=1
  • For example: if errorlevel 0 (echo Success) else (echo Failure)
• To automate the process, you can use Task Scheduler to set up a schedule (Press Win+R and then type taskschd.msc).
• To use Database .NET Pro 64bit, you need to add the parameter -m (For example, Database5Pro.exe -m -srctype:6 -desttype:9 ...etc)

支持二進制資料類型轉換BLOB type support - + + 篩選來源資料Filtering source data - + + 轉換來源資料Converting source data
* Creates a VIRTUAL TABLE whose contents (columns and rows) are defined by a query. - + + 相容於Compatible with
* 64位版本的能夠更有效率地處理超過 > 4GB(RAM) 以上的記憶體空間。The 64bit version can handle large amounts of random access memory(RAM) more effectively than 32bit. 32bit/64bit (<4GB) Native 64bit (>4GB) 支持作業系統Supported Platforms Vista~Win11 Vista~Win11 and
Windows Server Vista~Win11 and
Windows Server 授權模式Licensing models (終身免費升級Lifetime Free Upgrades) 非商業個人免費
台幣 0Non-commercial
USD 0 商業授權
台幣 1950Commercial Use
USD 65 商業授權
台幣 2970Commercial Use
USD 99 (#1) Built into Database .NET Professional 64bit. (Mainmenu -> Tools -> Data Migration or Command-line: Database5Pro.exe -m)
若您有任何問題, 請聯繫我 If you have any questions, please contact me at fishcodelib@gmail.com