Convert Dbf To Sql

 



DBF to SQL Converter allows you to convert your dbf files to SQL script.
You can apply this script on any SQL server, so you can easily transfer your data to a new system. There are several different SQL servers, but this program allows you to customize the output file. Currently it supports MS SQL, MySql, PostgreSQL, SQLite, etc.
You can also select various options, like type of quotes (single or double), using square brackets around field names, an action with carrier return and line feed symbols.
There are a lot of parameters that allow you to customize the output file.The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats.

The first tab allows you to select source files. You can select for conversion one or several files.
Double-click on a file displays a Preview window.

If your files contain non-latin characters then you have to choose a correct charset.

Command line parameter:
-incharset=windows-1251
-incharset=65001 (UTF-8)
In the command line you have to use an exact phrase or a code page.

Usually DBF files use single-byte encoding.

The second tab allows you to select the output folder or file.
If you selected a folder or checked the option
[x] Create a separate file for each source file
then every source file(table) will be converted to a separate output file.
i.e.

filename.dbf >> filename.sql
another.dbf >> another.sql

If you selected a file then a content of all source files will be converted to this file.

Command line parameters are:

-output=c:targettmp
-separate=1, -separate=0

Besides, you can define the program's behaviour what is necessary to do when an output file already exists.

Command line parameters are:

-files=overwriteOverwrite existing files
-files=useUse existing files (append to the end)
-files=skipSkip (do not convert a source file)
-files=uniqueCreate an unique name. example.sql, example.1.sql, example.2.sql, ...
-files=askAsk for action for each file

Encoding of the output file
Just select a desired value.
In the command line you have to use an exact phrase or a code page:
-incharset=windows-1251
-incharset=65001 (UTF-8)

The last tab allows you to customize the output file.

OptionDescriptionCommand line
[x] FieldsInclude field names-fields=1
-fields=0
[x] Drop tableAdd a command 'DROP TABLE'-drop=1
-drop=0
[x] InformationInclude a content (records)-info=1
-info=0
[x] Deletion markExport a deletion mark-deletionmark=1
-deletionmark=0
SyntaxThere are several predefined types of SQL Script. Just select most suitable for you.-sqltype=asis
-sqltype=sql2000
-sqltype=mysql
-sqltype=postgresql
-sqltype=sqlite
Quotes StyleYou can select 'double quotes', 'single quotes' or `apostrophes`-quotes=double
-quotes=single
-quotes=app
[x] Use brackests []Cunclude field names and table names in square brackets-brackets=1
-brackets=0
[x] Field names in INSERT commandUse field names in the INSERT command-names=1
=names=0
[x] Use `backticks`Cunclude field names and table names in ``-backticks=1
-backticks=0
Date formatJust select what is suitable for you.
the last format (yyyymmdd) does not contain delimiters		-date=mm-dd-yyyy
-date=dd.mm.yyyy
What to do with CR and LF symbolsYou can keep these symbols, remove them or replace to a custom string -removecrlf=0 (keep)
-removecrlf=1 (remove)
-crlf=# (replace)
Spaces in Character fieldsYou can remove trailing spaces, keep all spaces or remove both leading and trailing-spaces=trailing
-spaces=keep
-spaces=both
[x] Skip deleted recordsIf record is marked as deleted - do not copy it to the output file-skipdel=1
-skipdel=0
Style of Logical fieldsThis parameter allows you to override values from Logical fields to your own values.
Predefined:
-logical=AsIs
-logical=1,0
-logical=True,False
-logical=Yes,No
 User-defined example:
-logical=On,Off
Add GOYou can add the command 'GO' to the output file every few records-addgo=0
-addgo=500
Max file sizeIf the output file is too large, you can split it to several files. Define the maximum size in kilobytes.-maxfilesize=0
-maxfilesize=100

Besides there are some special command line parameters:

-log=c:tmpfilename.log create a .log file with debug messages
-batch run the conversion without prompt and display main window
-silent run the conversion without prompt and do not display main window
-key=your_key it allows to pass the registration key to the program and do not store it in program's settings
@c:pathparams.txt read command line parameters from file. One parameter per line.

If the converter does not have enough parameters or some error occurs then the batch process will be interrupted and the converter displays main window to resolve the problem.

After successful conversion you will see a list of output files.
Double-click on a file runs an associated program.
Right-mouse-click displays a Preview window.

Online Help

  • DBF to SQL Converter
  • XLS to JSON Converter
  • CSV to XLS Converter
Oracle to sql converter
Copyright © WhiteTown, 1996-2020

Convert Mysql Script To Mssql

Just launch DBF to SQL Converter, select source file (s), the output file/folder, select necessary parameters, such as a field delimiter, code page, quotes etc. Then click the button 'Expert mode' and you will see how all your settings become command line parameters! In the.dbf file folder, I have.fpt files also which are for 'memo' datatype I suppose. Another solution I tried is as below: I installed MS Visual Foxpro Driver and used the same for importing DBF files into SQL server 2008 but then I am able to 'Edit Mappings' and also can 'Preview' the data.

Convert Foxpro Dbf To Sql Server

  • Our DBConvert/DBSync for FoxPro and MSSQL provides a powerful and comfortable way to convert and sync data from MS Visual FoxPro databases (.dbc) and MS Visual FoxPro free tables (.dbf) to Microsoft SQL Server, Windows Azure SQL databases.
  • I want to convert several Table from foxpro (dbf, dbc) file to sql server. How can i do it? You can import dbf file to sql. You can follow instructions given Here.